Get connection string to .mdf file that is located in another DLL

Question

0.00/5 (No votes)

See more:

XML

Hi, i have encoutered following problem.
I have asp.net application named "Blog" and DLL with database named "DataAccess". DataAccess is referenced to Blog.
The Connection String that works and is located in Blog looks like:

     <connectionStrings>
    <add name="BlogDatabase" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\THERE\IS\FULL\PATH\Projects\BloggProject\DataAccess\App_Data\BlogDatabase.mdf;Integrated Security=True;Connect Timeout=30"/>
  </connectionStrings>

but what i want is something like this:

    AttachDbFilename=~\DataAccess\App_Data\BlogDatabase.mdf

where DataAccess is my DLL folder, i mean i want a connection string that is located in my asp.net application that points to this dll not only on my PC.

Thanks in advance.
Bartek.

Posted 23-Jun-14 11:07am

Member 10409338

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raul Iloc · Answer 1 · 2014-06-24T00:58:00

1.It is indicated to not mix Data Access Layer with User Interface Layer, so you should keep all data access code and associated database file in separate assembly (DLL).

If you want to access the database from your UI you should do it indirectly by invoking methods from your Data Access Layer.

2.Better is to access your database file (.mdf file) not from a suborder, but using a connection string that point to a SQL Server location like: "Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;"

In this way if you will need also from your web application to access directly some data from the database you will could use the same connection string (via your web.config file), but better is to use layers!