Entity Framework connection string connecting to file

Question

Is there a way to build Entity Framework connection string to connect to a file-Database in a standalone c# application?

What do you mean by "file-database"? Maybe you can checkout Biggy - A File-based Document Store for .NET github.com/robconery/biggy — Matija Grcic
– Matija Grcic, Commented Sep 19, 2014 at 5:47

Edi G. · Accepted Answer · 2014-09-19 06:25:50Z

1

Something like this ?

<add name="ConnectionName"
    connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|DatabaseName.mdf;Integrated Security=True;User Instance=True"
    providerName="System.Data.SqlClient" />

edited Sep 19, 2014 at 6:25

answered Sep 19, 2014 at 5:45

Edi G.

2,4207 gold badges25 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kishan Over a year ago

add @ before connection string connectionString=@""

Kjartan · Accepted Answer · 2014-09-19 05:55:09Z

0

You might take a look at Sql Express, which can be embedded directly into your application.

Quote from the page:

Do you need to embed SQL Server Express into an application? LocalDB is a lightweight version of Express that has all its programmability features yet runs in user mode and has a fast, zero-configuration installation. (...) LocalDB runs in-process with applications and not as a service.

You can download the installer from that same page.

answered Sep 19, 2014 at 5:55

Kjartan

19.2k16 gold badges75 silver badges102 bronze badges

Collectives™ on Stack Overflow

Entity Framework connection string connecting to file

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related