Entity Framework - "incorrect connection string" error

Question

I created a new model:

 public class AuthorDatacontext : DbContext
    {
        public DbSet<Author> Authors { get; set; }

        static AuthorDatacontext()
        {
            Database.SetInitializer(new DropCreateDatabaseIfModelChanges<AuthorDatacontext>());
        }
    }

A connection string:

  <add name="MyLibrary.Models.AuthorDatacontext" connectionString="Data Source= (LocalDb)\v10.0; Integrated Security=SSPI; AttachDBFilename = |DataDirectory|\MyLibrary.Models.AuthorDatacontext.mdf" providerName = "System.Data.SqlClient"  />

and i used it in my controller:

var db = new AuthorDatacontext();
                db.Authors.Add(author);
                db.SaveChanges();

I did it before, in another project and it worked fine. But now i receive an error, trying saving a new author:

An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.

What am i doing wrong? If i delete the connection and leave only the default connection, everything works fine.

The previous project had the same connection string:

<add name="MvcAuction.Models.AuctionsDataContext" connectionString="Data Source= (LocalDb)\v10.0; Integrated Security=SSPI; AttachDBFilename = |DataDirectory|\MvcAuction.Models.AuctionsDataContext.mdf" providerName = "System.Data.SqlClient"  />

radu florescu · Accepted Answer · 2013-05-08 09:03:38Z

1

I think the problem is that the EF tries to create the MDF again from your project. Try deleting it first.

\MvcAuction.Models.AuctionsDataContext.mdf the EF tries to see whether this exists in that location. If you had used SQL server it would have migrated changes from CODE First to database.

answered May 8, 2013 at 9:03

radu florescu

4,36310 gold badges64 silver badges95 bronze badges

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

8 Comments

Alexandra Orlov Over a year ago

but its another project. Why does it look for it?

radu florescu Over a year ago

You need a database to initialize your EF Context

Alexandra Orlov Over a year ago

How i create it? And why i didnt have this problem in the first project?

radu florescu Over a year ago

You should try to provide more details. You should have your own database for this project, because the one from other project won't be deployed.

Alexandra Orlov Over a year ago

I understand that. But in the previous project i just created the connection and the EF and everything else was created automatically. So what is the difference? What i supposed to add here?

|

Collectives™ on Stack Overflow

Entity Framework - "incorrect connection string" error

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related