ADO.Net 2.0: Relative paths in ConnectionString [Sushil Chordia]

re: ADO.Net 2.0: Relative paths in ConnectionString [Sushil Chordia]

Mayoor Patel — Fri, 28 Oct 2005 20:05:30 GMT

I don't know how it is going to be useful, as in your example, you still hardcoded the path.

>AppDomain.CurrentDomain.setData(“DataDirectory”,”C:\newPath\”);

Rather in such cases it is preferable to use AppSettings.

SqlConnection c = new SqlConnection (@“Data Source=.\SQLEXPRESS; Integrated Security=True;"+

e.g. @"AttachDbFilename=" AppSettings("MyDataFilePath") + "\Company.mdf;Initial Catalog=Company");
c.Open();

where MyDataFilePath is defined either in "AppSettings" section of App.Config or Web.Config.

re: ADO.Net 2.0: Relative paths in ConnectionString [Sushil Chordia]

DataWorksBlog — Fri, 28 Oct 2005 20:37:30 GMT

Mayoor, Thanks for the feedback on the post. The ideal approach would be to put one single connection string (with the substitution string)in your configuration files and then change the Substitution strings in your code based on custom logic. The example above was to just illustrate how to add custom paths, I agree that it is a good idea to have the path defined in some other config file to reuse in you code. In doing so, you wont have to change your connection string with the above example.

one question, though

Sam — Tue, 08 Nov 2005 10:37:20 GMT

what would happen if you use |DataDirectory| connecting to a different computer - for example the program could be running on a xp comp named 'kurt', and connects to a SBS 2003 running the SQL Server named 'karin' - the SBS 2003 server can't store the database on the xp client, so where will it go, pathwise?

re: ADO.Net 2.0: Relative paths in ConnectionString [Sushil Chordia]

Pragya — Thu, 24 Nov 2005 10:03:05 GMT

Useful post. I could not find this little bit of information on msdn though!

re: ADO.Net 2.0: Relative paths in ConnectionString [Sushil Chordia]

Kevin Jones — Mon, 09 Jan 2006 16:57:23 GMT

Sushil,

can you confirm that AppDomain.CurrentDomain.SetData("DataDirectory", "path-to-dir") still works in the RTM bits?

I've had this working but it's now stopped and I've seen other blog entries claiming this doesn't work. I wonder if there was some change between a late beta/CTP and the release

re: ADO.Net 2.0: Relative paths in ConnectionString [Sushil Chordia]

Sushil Chordia — Mon, 16 Jan 2006 23:04:32 GMT

Pragya, Thanks for your feedback.
-Sushil

re: ADO.Net 2.0: Relative paths in ConnectionString [Sushil Chordia]

Sushil Chordia — Mon, 16 Jan 2006 23:06:59 GMT

Kevin, I still see the function (AppDomain::SetData(str, object) being public in the RTM bits. This method has been public since 1.1 days. Here is a link to its documentation. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemappdomainclasssetdatatopic.asp

Hope that helps,
Sushil Chordia

Simon says - SqlExpress, User Instance = true

Simon says - SqlExpress, User Instance = true — Fri, 24 Nov 2006 21:52:28 GMT

PingBack from http://www.primetime-software.de/simon.steckermeier/PermaLink,guid,e9648ca4-81e7-4caf-b6d1-400a88a7a598.aspx

free music videos myspace codes

free music videos myspace codes — Tue, 18 Sep 2007 03:04:14 GMT

free music videos myspace codes

music video codes myspace html

music video codes myspace html — Tue, 18 Sep 2007 03:04:46 GMT

music video codes myspace html

free myspace music background codes video

free myspace music background codes video — Tue, 18 Sep 2007 03:05:01 GMT

free myspace music background codes video

Drugs and Movies » Data Access blog : ADO.Net 2.0: Relative paths in ConnectionString …

Wed, 09 Apr 2008 05:27:59 GMT

PingBack from http://drugsmoviesblog.info/data-access-blog-adonet-20-relative-paths-in-connectionstring/

How to attach mdf in a relative directory | keyongtech

How to attach mdf in a relative directory | keyongtech — Thu, 22 Jan 2009 08:18:50 GMT

PingBack from http://www.keyongtech.com/445835-how-to-attach-mdf-in

Data Access blog ADO Net 2 0 Relative paths in ConnectionString | Outdoor Ceiling Fans

Sun, 31 May 2009 21:43:16 GMT

PingBack from http://outdoorceilingfansite.info/story.php?id=22789

Data Access blog ADO Net 2 0 Relative paths in ConnectionString | work from home

Data Access blog ADO Net 2 0 Relative paths in ConnectionString | work from home — Tue, 16 Jun 2009 16:05:05 GMT

PingBack from http://workfromhomecareer.info/story.php?id=8407

Data Access blog ADO Net 2 0 Relative paths in ConnectionString | fix my credit

Data Access blog ADO Net 2 0 Relative paths in ConnectionString | fix my credit — Wed, 17 Jun 2009 05:44:58 GMT

PingBack from http://fixmycrediteasily.info/story.php?id=3237