Tag Archives: SQL

C# Using Dapper as your SQL framework in .NET Core

Dapper is a easy to use object mapper for .NET and .NET Core, an it can be used a variety of ways. I use Dapper instead of Entity Framework because it makes my code less complex. BASICS OF DAPPER: THE … Continue reading

Posted in .net, .NET Core, c#, General .NET | Tagged , , | Leave a comment

System.DllNotFoundException: Unable to load DLL ‘sni.dll’ or one of its dependencies: The specified module could n ot be found. (0x8007007E)

This message happens when deploying my .NET Core 3.1 application to production (when compiling the code to an .exe file), but not when running the application locally. It turns out, that Dapper is missing a reference to System.Data.SqlClient. Adding the … Continue reading

Posted in .net, .NET Core, c# | Tagged , , | 1 Comment

Improve Sitecore Membership provider performance 2-20 times

Sitecore Membership performance can be increased dramatically by changing stored procedures and create new indexes. Try this before you write your own membership provider. Continue reading

Posted in Sitecore, Sitecore 6, Sitecore 7 | Tagged , , , | 8 Comments

Sitecore poor database performance

If you experience decreasing performance in your Sitecore solution, it’s not always your fault. And it’s not always Sitecore’s fault either. The database is usually the last place I would look for performance issues. Most performance issues comes from poor XSLT … Continue reading

Posted in Sitecore 6 | Tagged , , , , | 1 Comment