LINQ and Web Application Connection Strings

Noticias externas — Mon, 26 Nov 2007 04:04:43 GMT

It's usually a good idea to seperate Biz Layer Objects and Data Access Objects into seperate assemblies

re: LINQ and Web Application Connection Strings

Daniel — Thu, 06 Dec 2007 17:58:33 GMT

But what if i want to have the datacontext load its connection strings from its own app.config?

because i find this approach, adding an app.config to the datacontext project and compiling the settings into the dll, really, really, really dumb...

although it makes the build subject to automation/continuous integration (build process, modify settings, pack the files).

Thank you,

Dan

re: LINQ and Web Application Connection Strings

jongallant — Thu, 06 Dec 2007 18:13:41 GMT

Dan - An app.config file is added to Class Library projects by default when you add a new LINQ to SQL (dbml) file to the project. If you follow the steps above your app.config connectionStrings will work the same way web.config connectionStrings will.

Jon

re: LINQ and Web Application Connection Strings

David Klein (Oakton) — Mon, 18 Feb 2008 09:39:27 GMT

Hi Jon, - you don't need to delete code from the designer. There is a property that you can set on the dbml as per my blog entry that tells the designer not to generate the empty constructor. See

http://ddkonline.blogspot.com/2008/02/set-connection-string-in-linq-dbml-file.html

re: LINQ and Web Application Connection Strings

Sebastian Paul — Sat, 29 Mar 2008 18:59:39 GMT

Hi,

for those who don't want to change the generated code, here's another approach:

Create a new cs file for the partial code.

Implement OnCreated as follows:

partial class MyDataContext

{

partial void OnCreated()

{

ConnectionStringSettings s = ConfigurationManager.ConnectionStrings["MyConnection"];

if (s != null) Connection.ConnectionString = s.ConnectionString;

}

The data context will use the connection string, if found.

re: LINQ and Web Application Connection Strings

oyesil — Wed, 22 Oct 2008 23:00:13 GMT

Sebastian, this is a great solution, how come I couldn't think this :).. thanks alot..

re: LINQ and Web Application Connection Strings

Siva — Fri, 05 Dec 2008 09:32:19 GMT

Thanks a lot Sabastian. very helpful and saved me a lot of time. Thanks once again

re: LINQ and Web Application Connection Strings

Alex — Thu, 16 Apr 2009 19:32:05 GMT

in dbml you can specify a different BaseClass

public class DataContextBase : System.Data.Linq.DataContext

{

private static string overrideConnectionString = ConfigurationManager.ConnectionStrings["CString"].ConnectionString;

public DataContextBase() : base(overrideConnectionString) { }

public DataContextBase(string connectionString) : base(overrideConnectionString) { }

public DataContextBase(string connectionString, System.Data.Linq.Mapping.MappingSource mappingSource) : base(overrideConnectionString, mappingSource) { }

public DataContextBase(IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) : base(connection, mappingSource) { }

}

re: LINQ and Web Application Connection Strings

Tommy Newcomb — Thu, 15 Oct 2009 16:29:55 GMT

Thanks that works great. I did a search on my connstring password and it was all over the place in my code using Linq to SQL. Using the example above puts it back in 1 place in the config file. I love Linq to SQL, but stuff like this makes me wonder about MS.