Creating DataContext with opened Connection

Creating DataContext with opened Connection

Postby ath » Wed 28 Nov 2012 13:08

Currently, I am in evaluation period of testing LinqConnect.
My first step is to change "Linq To SQL" to "Devart.Data.Linq" on our project. Now it connects to SQL Server but in near future we would also like to work with SQLite. I have problem with creating DataContext instance. It is used like this:
Code: Select all
***DataContext ctxOrg = new ***DataContext(Connection);
ctxOrg.Transaction = Transaction;

Connection and Transaction objects are managed by other project. DataContext(IDBConnection) constructor gets opened Connection. During creation of DataContext I get an exception: Cannot change ConnectionString property. Connection is opened.
I don't want to change business logic currently implemented in this solution.
How to solve this problem?
ath
 
Posts: 5
Joined: Wed 28 Nov 2012 12:50

Re: Creating DataContext with opened Connection

Postby MariiaI » Thu 29 Nov 2012 13:20

Thank you for the report. We have fixed the issue with creating DataContext with an opened connection. The fix will be included in the next build of LinqConnect. We will inform you when it is available for download.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Creating DataContext with opened Connection

Postby ath » Tue 04 Dec 2012 08:45

Thanks for reply. When this build will be available for download? 1-2 days or 1-2 months?
ath
 
Posts: 5
Joined: Wed 28 Nov 2012 12:50

Re: Creating DataContext with opened Connection

Postby MariiaI » Tue 04 Dec 2012 10:23

We plan to release the next build of LinqConnect in 1-2 weeks. We will certainly inform you when it is available for download.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Creating DataContext with opened Connection

Postby MariiaI » Fri 21 Dec 2012 08:07

New build of LinqConnect 4.1.151 is available for download now!
It can be downloaded from http://www.devart.com/linqconnect/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=31&t=25515
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Creating DataContext with opened Connection

Postby ath » Thu 27 Dec 2012 14:52

Thanks for information. Unfortunately, I cannot test this version because my Trial period has expired... :(
ath
 
Posts: 5
Joined: Wed 28 Nov 2012 12:50

Re: Creating DataContext with opened Connection

Postby StanislavK » Fri 28 Dec 2012 13:38

We've contacted you by mail, please check that the letter was not blocked by your mail filter.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to LinqConnect (LINQ to SQL support)