Dapper Tutorial - Knowledge Base (KB)

Generate a SQL clause using a Linq-to-Sql Expression

I would like to create a repository model that could take an Expression and use Linq-To-Sql to generate the required SQL statement....For example, I have a function such as this:...// Possible criteria Expression<Func<Purchase,bool>> criteria1 = p => p.Pr...

How to call a L2S provider to translate a predicate in form of Func<T,bool> to a SQL where clause?

I am using L2S in my application but i'm switching more and more to ...dapper.net... because i'm having major issues with query performance and the annoying ...n+1 selects... problem....Its working fine, but i miss the comfortable LINQish style of writing...

xUnit test deadlock

When I run my xUnit unit tests I sometimes get an error message like "Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim" on one or more of the tests, seemingly randomly. If I re-ru...