Contents tagged with Linq to SQL
-
Back in the Saddle
Back to the grind. Actually, I've been back to the grind for weeks but haven't been blogging due to time constraints. 2007 ended with a fender bender followed by my eldest daughter going to the hospital in East Podunk New Hampshire with 105 F fever and pneumonia. She's much better and the folks were nice enough if not exactly happy to be there on Christmas Day. Then 2008 started with my dog being diagnosed with terminal lung cancer. She had to be euthenized immediately because a tumor had completely blocked her esphagus preventing her from ever eating again. That really sucked since my wife had never lost an animal before. Bad day. Then my youngest daughter went in for major surgery three days later. It was planned but she wasn't drinking enough on her own after surgery so she had to stay in the hospital for an extry day (3 total). Thank God it was at Johns Hopkins, agruably the best hospital in the world. A far cry from the places we spent nightmare days in China. Then I get my first speeding ticket in YEARS. Not exactly a slap on the face, more of a flick on the ear.
-
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.
-
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.