[dba-SQLServer] [dba-SQLserver] Article: LINQ and stored procedures

Hi all

And here is what looks like a clever (and free) tool for SQL freaks to get a jumpstart with LINQ in Visual Studio:

  http://www.linqpad.net/ 

Just download and run. Visual Studio is not(!) needed. A bunch of help and examples and several chapters from the book "C# in a nutshell" is included.

/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