SQL

Here's how we use the data protection features within SQL Server to protect confidential data and make it available to only those authorized to see it.

In CAML, you’re forced to create some crazy if…else if… else if… scenario for all possible combinations of search parameters. Here's how I resolved it.

Entity Framework 6.0 was recently released. One of the new features added is called Interception. You can now add “hooks” into each Context to catch events to log or even change values. Setting up these Interceptors is very simple. First, you need to create the Inteceptor class. There are two interfaces that you can use: IDbCommandTreeInterceptor and IDbCommandInterceptor. …

Entity Framework 6.0 – Intercepting SQL produced by EF Read More »