August 2012 – Knowledgebase

How to make Entity Framework 5.0 use an in-memory persistence DbContext instead of accessing the database.

23 August, 2012 Roel van Lisdonk 5 Comments 1 category

If you want to switch between in-memory stub data and a database during runtime with Entity Framework 5.0, you have several options, some of them are: – Using a second level cache mechanism like http://www.codeproject.com/Articles/435142/Entity-Framework-Second-Level-Caching-with-DbConte

How to convert / cast the current server date and time to a varchar in the format YYYY-MM-DDThh:mm:ss[+|-]hh:mm in T-SQL

13 August, 2012 Roel van Lisdonk 0 Comments 1 category

To convert the current machine date and time to a varchar in the format YYYY-MM-DDThh:mm:ss[+|-]hh:mm in T-SQL, you can use the following code: select convert(varchar(100), cast(sysdatetimeoffset() as datetimeoffset(0)), 126) Result (in Amsterdam in

Month: August 2012

How to make Entity Framework 5.0 use an in-memory persistence DbContext instead of accessing the database.

How to convert / cast the current server date and time to a varchar in the format YYYY-MM-DDThh:mm:ss[+|-]hh:mm in T-SQL