datatableadapters

Quality of the autogenerated sql queries in Visual Studio

I was having an issue with the auto generated delete statement. In my mind the delete should have just been DELETE [tablename] where [PK] = @param but instead it generates a query with 4 ORs. DELETE FROM Market WHERE (@IsNull_Name = 1) AND (Name IS NULL) AND (@IsNull_Description = 1) AND (Description IS NULL) AND (MarketId = ...

LINQ to DataSet Dataclass assignment question

Hi all, I'm working on a Silverlight project trying to access a database using LINQ To DataSet and then sending data over to Silverlight via .ASMX web service. I've defined my DataSet using the Server Explorer tool (dragging and dropping all the different tables that I'm interested in). The DataSet is able to access the server and dat...