Coming soon to LINQ to SQL

Published 21 February 08 11:28 AM | dpblogs 

LINQ to SQL went gold a few months ago with the release of Visual Studio 2008 and .NET Framework 3.5. It has been somewhat quiet since then – and as we near the launch of Visual Studio 2008, you may be wondering what we have been up to.

 

Things aren’t so quiet over here on our end, even if it looks that way. The team has been busy adding features so that you will have better support for SQL Server 2008 in the future. Things we’ve been working on include support for new T-SQL data types that are being introduced in SQL Server 2008 – namely DATE, TIME, DATETIME2 and DATETIMEOFFSET, so that you can enjoy the same rich LINQ support and CUD support over data that uses many of the new types that are being introduced in SQL Server 2008.

 

Watch this blog for more on this as we get closer to releasing some of this functionality!

 

Faisal Mohamood

Program Manager – LINQ to SQL

Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# BioSensorAB » Coming soon to LINQ to SQL said on February 21, 2008 2:40 PM:

PingBack from http://www.biosensorab.org/2008/02/21/coming-soon-to-linq-to-sql/

# Alex said on February 21, 2008 5:04 PM:

Hi this is a great news!

Thank you very much!!!

We are looking forward for RTM version!

We were using previous version and it works just great!

# Elisa Flasko's Blog said on February 21, 2008 8:08 PM:

Wondering when you'll get to use the new SQL 2008 Data Types with LINQ to SQL? Check out a new post by

# Noticias externas said on February 21, 2008 8:41 PM:

Wondering when you'll get to use the new SQL 2008 Data Types with LINQ to SQL? Check out a new post

# Andy said on February 22, 2008 1:29 AM:

Are you planning to add support for the location data types too?

# Charlie Calvert's Community Blog said on February 22, 2008 3:54 AM:

Faisal Mohamood , the LINQ to SQL Program Manager, has posted about the work his team has been doing

# Matthieu MEZIL said on February 22, 2008 10:09 AM:

Faisal Mohamood vient d'annoncer le support des nouveaux types de SQL Server 2008 : DATE, TIME, DATETIME2

# Beth Massi - Sharing the goodness that is VB said on February 22, 2008 8:26 PM:

Check it out, on the ADO.NET Team blog Faisal Mohamood, a PM on the LINQ to SQL team, posted on the new

# ASPInsiders said on February 22, 2008 8:38 PM:

It's funny when you work at a company that has as many small projects as it has big ones. I hear one

# Noticias externas said on February 22, 2008 9:25 PM:

Check it out, on the ADO.NET Team blog Faisal Mohamood, a PM on the LINQ to SQL team, posted on the new

# Vijay Santhanam said on February 23, 2008 2:01 AM:

Spacial data type support will be my favourite.

I wonder what namespace/assembly these new .net data types will be added to

# juliel said on February 23, 2008 9:47 AM:

When is this slated for? Charlie Calvert says "next release", but what is the defintion of that? SP1? The next version of Visual Studio? Something else?

Thanks

Julie

# Daniel Simmons said on February 23, 2008 2:12 PM:

Something to keep in mind that may not have been clear from the post above is that while LINQ to SQL will have support for some of the new SQL Server 2008 types.  It won't, unfortunately, support the new spatial data types.  That's something which will have to come at a later time.

- Danny

# Michael Washington said on February 24, 2008 10:13 AM:

Linq to SQL is one of the greatest achievements ever to come out of Redmond.

# Jim Wooley said on February 24, 2008 6:00 PM:

I'm assuming this means that the designer will support SQL 2008 (minus the spatial data types) as well.

# Matthieu MEZIL said on February 25, 2008 3:35 AM:

Suite à l'annonce faite pour LINQ To SQL , Julie s'est posée la question de ce qu'il en était pour l'Entity

# Peter V. said on February 26, 2008 2:13 PM:

Great news Linq to Sql will soon support the SqlServer 2008 data types!

Will there be also improved tools for Linq to Sql? Like the model designer that can update the dbml-file when there were changes to the database?

Peter

# Other Blogs we recommend said on February 26, 2008 3:27 PM:

Quite a bit of activity last week in the Visual Studio and ORM spaces. Visual Studio released a CTP of

# Mark D said on February 27, 2008 1:25 PM:

Support for CLR UDT's would be good.

# Hot Topics said on February 28, 2008 11:18 AM:

Faisal Mohamood, PM for LINQ to SQL, discusses upcoming changes to LINQ to SQL in this blog post . "Things

# Fduch said on February 29, 2008 1:09 AM:

Why, oh why did you make the ExpressionVisitor class internal and then published it's code (crippled) in MSDN?

I see no logic here.

# Kevin said on March 3, 2008 6:05 PM:

Will the LINQ to SQL designer support updating the dbml file when the schema changes?  Currently, my project is getting to the point were the LINQ to SQL designer will become unusable without this feature. :-(

# Andy said on March 7, 2008 10:44 AM:

@Kevin.... I agree, schema changes seem a weak point in the designer support.

# Faisal Mohamood said on March 13, 2008 9:54 PM:

Support for schema changes unfortunately didn't make it into the first release of LINQ to SQL. It certainly is among the features we are hoping to add for LINQ to SQL - but at this point it is too early to tell when it will be available.

-Faisal

# geo said on March 21, 2008 8:41 PM:

Please add a better way to no nolock

# Kate said on March 24, 2008 11:51 PM:

Hello,

Have you heard about a new database synchronization tool Datbase Restyle (http://www.perpetuumsoft.com/Product.aspx?lang=en&pid=55) that supports LINQ To SQL object model and allows automatic synchronization if LINQ To SQL object model with your live database? Probably, this tool will be helpful.

# Freedom said on March 25, 2008 10:58 PM:

Any word on support for the XML Datatype?

# Kate said on March 28, 2008 3:15 AM:

This product supports XML Datatype as well. You should just try it.

Kate.

# dcazzulino said on May 30, 2008 4:17 AM:

It does not support XML Datatype-based queries, though. All you can do is retrieve the XElement in the loaded result set, but not specify a LINQ 2 XML (or XQuery, which is supported by SQLServer 2005+) as a filter.

# Kris said on August 28, 2008 3:04 AM:

@Kevin,

I have written an add-in that can update the dbml file with db schema changes. (and a few other tricks too)

You can download it and try it out - http://www.huagati.com/dbmltools/

# watch moviez online said on January 10, 2009 6:06 AM:

Hi this is a great news!

Thank you very much!!!

# gemery said on May 8, 2009 11:34 AM:

how about UDT support for semi-native Sql Types. That being the new spacial stuff. Talk a show stopper. It would be cool if i could just import the binnary as a refrence and then l2sql could use that..

# gemery said on May 8, 2009 11:34 AM:

how about UDT support for semi-native Sql Types. That being the new spacial stuff. Talk a show stopper. It would be cool if i could just import the binary as a reference and then l2sql could use that..

# Dan-El said on June 1, 2009 10:07 AM:

Check out http://www.codeproject.com/KB/linq/LINQ_to_SQL_Database_Sync.aspx

An open source utility that synchronizes your database structure with a LINQ to SQL model.

Leave a Comment

(required) 
(optional)
(required) 

  
Enter Code Here: Required

Search

This Blog

Syndication

Page view tracker