Been working a bit with Microsoft SQL Server 2012 and spatial features using the Geography data type. I'm using it from ADO.Net hence I make use of the Microsoft.SqlServer.Types library. Didn't take long to get annoyed about the API in there. Let's have a look. There´s a type: SqlGeogr…
Daniel Wertheim
Recently I got a bug report in SisoDb where a document got truncated hence when getting deserialized back, the deserialization process blow up. After a short investigation I found this truly amazing bug in SQLCE4. If you have a field being nvarchar(4000) and you use a command parameters that has a v…
Daniel Wertheim
This is a quick post showing you the behaviour of ConcurrentDictionary.GetOrAdd [http://msdn.microsoft.com/en-us/library/ee378677.aspx], which might not be what you expect. I bet that when you first read it, you think: > If the key exists, the corresponding value is returned; if not the Func is…
Daniel Wertheim
The scenario A while back ago I had to yield entities constructed by deserializing JSON stored in a database. The first solution just opened a simple single result, sequential reader against the database returning a one column result set containing JSON. This was just yield returned after deserializ…
Daniel Wertheim
Today I got involved in a small question on Twitter on how to create a generic factory creating instances of classes having a private constructor. So I put together a small sample that shows two solutions: * Using Activator (around 22s per 100000) * Using compiled lambdas (around 8s per 100000)…
Daniel Wertheim