Archives
-
Linq to SQL Null Value Handling
Here is what SQLMetal generates when you have a column in your database that allows nulls:
-
SQL Metal and Linq - Refreshing Schema Warnings
So it turns out the simplest way to update your dbml schema is to just delete the existing files and recreate them with SQL Metal. Then, when you include the updated dbml file in your VS 2008 project you will get new dbml.layout and .designer.cs files. You'll of course have to reset your layout if you've modified that. If you do this, you're safe. If you need that layout, continue reading.
-
Good Day to be a Programmer
So I'm looking at all the new stuff that was just released and the things that are going to be released soon. It's a good time to be a programmer in the Microsoft way as long as you are aligning yourself appropriately with the stars.
-
Using SQL Metal To Get Connected with Linq
SQLMetal.exe is the command line tool that will allow you to very quickly spin up the object model you'll need to connect from your SQL Server database via Linq. Here are the basics of using SQLMetal.
-
Linq to SQL with VS 2008 and MOSS
So here's my current plan for firing up these new technologies. As background, I gave a 15 minute presentation at a user group last night on the generalities of data abstraction and although I think I did ok, I also think that there are a lot more questions than answers in the developer community right now with regard to how to get data back into SQL Server through Linq.