SQL Server | The Difficult Bit

Capturing SQL Statements Generated by LINQ to SQL

LINQ to SQL generates SQL statements to send to SQL Server. In the case of problems with these, for example unexpected results or poor performance, it is useful to be able to capture this SQL. This can then be run and investigated separately. It is also sometimes useful to get a feel for the number […]

Rounding .Net DateTime to match SQL Server

The SQL Server DateTime type is represented by LINQ to SQL as a .Net System.DateTime type. This presents a small problem in that the .Net type supports more precision – a “tick” representing 100 nanoseconds – than the SQL type which is “rounded to increments of .000, .003, or .007 seconds”. It is worth noting […]