Devart LINQ to SQL support in dotConnect for SQL Server

Devart LINQ to SQL support in dotConnect for SQL Server

Postby crazypit » Wed 24 Mar 2010 11:44

Hello,

I've been using the LINQ support in dotConnect for Oracle for quite some time now.

I need to have the ability to connect my application to a number of different database types without making any changes to my code. All my DB access is performed through LINQ. I'm particular interested in switching between Oracle & MS SQL Server.

In theory, this should be an easy task as the LINQ code is not depended on the type of the database.

In practice though, i see some potential pitfalls. For starters, there is no LINQ to SQL support in dotConnect for SQLServer! And before anyone says that the Microsoft implementation will do just fine and there is no need for such a thing, i will mention that there is a number of Devart extensions that are implemented in dotConnect for Oracle and not available in Microsoft implementation. For instance, one of my favorite is the DataContext.Query method that gets an SQL string and returns an IQueryable. This method is used in my application in a large number of places. How i'm i supposed to go without it in an SQL Server installation?
crazypit
 
Posts: 163
Joined: Wed 15 Apr 2009 08:43

Postby AndreyR » Thu 25 Mar 2010 14:56

There is no LINQ to SQL support in dotConnect for SQL Server.
However, we are working on LinqConnect - a product that will integrate our LINQ support.
It will have SQL Server support. Some other features:
  • ValueType support;
  • Key generators;
  • Query Caching;
  • Possibility to generate DataContext without attributes.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby crazypit » Fri 26 Mar 2010 07:17

It's seems a cool product!

Can we have at least a far estimate on the release date?
crazypit
 
Posts: 163
Joined: Wed 15 Apr 2009 08:43

Postby AndreyR » Fri 26 Mar 2010 08:46

We plan to release the Beta version of LinqConnect in a month or so.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Thu 22 Apr 2010 12:34

Devart LinqConnect Beta is available for download:
http://www.devart.com/news/2010/linqconnect100b.html
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby crazypit » Thu 22 Apr 2010 12:41

Do in need to remove dotConnect for Oracle in order to install this?
crazypit
 
Posts: 163
Joined: Wed 15 Apr 2009 08:43

Postby AndreyR » Thu 22 Apr 2010 13:09

Unfortunately, LinqConnect is not compatible with the current version of dotConnects.
But LinqConnect contains Express versions of all providers and LINQ support for all of them.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to LinqConnect (LINQ to SQL support)