[dba-SQLServer] Article: LINQ and stored procedures

As requested recently by JC:

>From the cover story "The Next Generation: Visual Studio 2008":

<quote>
LINQ speeds up application development by providing immediate fedback through IntelliSense and compile time error checking that wasn't possible using the older dual-mode ADO.NET and T-SQL development methodology.
</quote>

/gustav

>>> Gustav at cactus.dk 29-03-2008 10:59 >>>
Hi all

It looks like MS is thinking of Visual Studio as a major tool for controlling SQL Server.
An interesting article by William Sheldon in SQL Server Magazine tells more, indeed about the SQLMetal tool:

<quote>
Microsoft Visual Studio 2008 and Language Integrated Query (LINQ) queries convert Visual Basic and C# code into T-SQL*based database calls, which are executed against SQL Server. Your Microsoft Visual Studio 2008 projects will need to target the Microsoft .NET Framework 3.5 to use LINQ. SQLMetal generates the necessary data entity and DataContext object as either a .vb or .cs source file. 
</quote>

http://sqlmag-pwf.texterity.com/sqlmag/200804/ 

Pick article:
LINQ to Your SQL Server Data 

A registration is needed but that is free.

/gustav