SqlDataSources Unusable if Tables Allow NULL's


 I've been working on a problem for a client's project.  We are doing pretty raw RAD design for a small intranet project so I thought, hey let's just do SqlDataSources to get the pages up and running fast.  This works fine *if* we don't want any concurrency. 

Let me repeat that, this works fine *if* we do not want concurrency. 

The problem lies in the fact that we have columns that are null-able (pretty common in schema design).  The concurrency that is generated by ASP.NET 2.0's SqlDataSource does not do the same concurrency (e.g. WHILE foo = @foo OR (foo is null and @foo is null)) that Typed DataSets and CommandBuilders have done for several years. 

My guess is that this is another example of how fractured the data teams in Microsoft are.  One team does DataSets, which another does Typed DataSets, and if I am correct, yet another does the DataSource work. 

Arg!



Shawn
Shawn Wildermuth
Author, Teacher, and Coach




My Courses

Wilder Minds Training
Vue.js by Example (New Lower Price)
Bootstrap 4 by Example (New Lower Price)
Intro to Font Awesome 5 (Free Course)
Pluralsight
Building an API with ASP.NET Core (New Course)
Building a Web App with ASP.NET Core, MVC6, EF Core, Bootstrap and Angular (updated for 2.2)
Less: Getting Started (New)
Using Visual Studio Code for ASP.NET Core Projects
Implementing ASP.NET Web API

Application Name WilderBlog Environment Name Production
Application Ver v4.0.30319 Runtime Framework x86
App Path D:\home\site\wwwroot\ Runtime Version .NET Core 4.6.27817.01
Operating System Microsoft Windows 10.0.14393 Runtime Arch X86