Using Dapper with the Telerik Blazor grid
Due to some performance issues, I decided to try using Dapper with the Telerik grid for Blazor. This post documents the (excellent) results, and shows a useful extension method that makes this very simple.
Search
Showing posts tagged SQL Server.
How to change the schema for an SQL Server database user and all existing tables
Not rocket science, nor anything new or startling, but I seem to bump into this issue every now and then, and always have to go searching to remind myself how to fix it.
Exporting a database from Azure and importing it into SQL Server
Following a lot of frustration with the Azure portal, I discovered of a quick and easy way to transfer an Azure database to a regular SQL Server.
Changing the data type and length of columns in existing SQL Server tables
Faced with the task of modifying every varchar(n) column of every table in a database to be varchar(max), whilst avoiding default constraint errors, I came up with a script to generate the SQL for me.
Func vs Expression - The LINQ expression node type Invoke is not supported in LINQ to Entities
I had an odd problem, the resolution of which exposed an interesting bit of information about what goes on under the C# covers that we never usually know.
I had a Linq query that worked fine on its own, but failed at run time when I extracted it into a method and passed in a lambda.
Whilst trying to work out why this was happening, I came to an understanding of the difference between a Func and an Expression, and why it (sometimes) matters.
More great error messages
Following on from my previous posts with great error messages, here are some more
Using SQL Server full-text search from Entity Framework - An agony of many fits
Update (15th May '18) : I have done something similar recently, and discovered that you don't seem to need to set EXEC permission on the stored procedure any more. not sure if this is because we upgra…
