I’m on DNR next week

I had the good fortune to be able to spend an hour or so (may have been a bit longer 😉 chatting with Richard and Carl last week on .NET Rocks! about SQL Server 2005 and the state of the world in general. This episode should be available on Tuesday, Apr 18 at the usual places, Franklin’s.NET and MSDN. Although the topic was originally to be SQLCLR, things quickly shifted into a discussion of snapshot isolation (aka versioning), Service Broker, XML support, statement-level recompilation and other topics database folks enjoy talking about. Hope you’all enjoy it.

2 thoughts on “I’m on DNR next week

  1. Hi.

    I’m not sure if this is the right place to ask my question, but anyway I do, if it’s not, simply remove it, and I’m sorry.

    Well, you’ve made great improvements, thanks a lot. The nullable types in .Net 2 make working with nullable columns in the database much easier. But little support is added in the datasets: auto-generated methods in table adapters support nullable types, but in the table itself (in the dataset designer) we can’t set the type of the column as a nullable, so the only allowed value for the NullValue property is: throw exception. I want to ask if there is a solution in your minds that I don’t know.

  2. Hi Alireza,

    You are correct that there is not built-in support for Nullable types in the DataSet. You’d have to code this support yourself using the TableAdapter or a different mechanism. I’ve seen workarounds on blogs, you might try a quick web search and see if any of these fits the bill. I was able to find one with TableAdapters on Rich Czyzewski’s Blog, for example. But it’s not built-in.

Comments are closed.

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.