The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

    • RT @askimono: Leestip: nog een herkenbaar stuk, over de worsteling en twijfel als China-correspondent of je de afgelopen maanden de zich vo… 44 minutes ago
    • @AtypistAnne Vroeger meestal te laat. Sinds 15 jaar meestal te vroeg. 1 hour ago
    • RT @HWHofs: Wat is nepnieuws verspreiden toch ziek en schadelijk. 2 hours ago
    • @matijn Dank! Nooit geweten dat bij dat prachtige nummer deze bijzonder hoes hoorde (: 2 hours ago
    • @matijn Af en toe ben je best vreselijk! De wraak van Mika zal zoet zijn. Ben benieuwd.... 2 hours ago
  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,874 other followers

Archive for October 23rd, 2013

Tables with SQL Server and .NET data types

Posted by jpluimers on 2013/10/23

Thanks StackOverflow users George Stocker for asking, Örjan Jämte and Sir Crispalot for answering.

Below is the SQL Server 2012 table, in which I added links to the various data types.

I also added two columns with linked references to the types from the  C# data typesC# KeywordsReference Tables for Types (C# Reference) and Data Type Summary (Visual Basic).

One of the things I need to check is against the LINQ SQL-CLR Type Mapping.

It is very important to keep in mind that in SQL, each combination of precision and digits gets you a different decimal type, and all of them are different from the .NET decimal type. See for instance the answers on these questions:

Read the rest of this entry »

Posted in .NET, .NET 2.0, .NET 3.0, .NET 3.5, .NET 4.0, .NET 4.5, Algorithms, C#, C# 1.0, C# 2.0, C# 3.0, C# 4.0, C# 5.0, Database Development, Development, Floating point handling, Software Development, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Leave a Comment »

%d bloggers like this: