System.Data.SqlTypes or NULLABLE native types?

Question

If you are using a SQL Server database and you want to store null and non null values read from the database, which .NET data types are best suited, NULLABLE native types or SQLTypes?

I don't care about db portability to a different db.

Pieter van Ginkel · Accepted Answer · 2010-11-11 20:33:23Z

1

This 100% depends on what you're going to do with it. If you're interacting with SqlCommands and associates, you for example have to use DbNull. However, my experience is that its usefulness stops there. With the rest of .NET, you're better off with native types. WPF for instance now supports Nullable<bool> for CheckBox.IsChecked which binds very well to native types, but not as nicely to the SQL types.

answered Nov 11, 2010 at 20:33

Pieter van Ginkel

29.7k8 gold badges77 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

System.Data.SqlTypes or NULLABLE native types?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related