entity framework - EF Code First - creating database - Login failed for user -



entity framework - EF Code First - creating database - Login failed for user -

i had ef code first set connecting existing database. working fine.

i made couple changes poco , decided have code first generate new database me.

getting error: cannot open database \"mydatabase\" requested login. login failed.\r\nlogin failed user 'domain\username'.

i deleted old database, did not alter connection string:

<add name="mydatabasecontext" connectionstring="data source=localhost;initial catalog=mydatabase;integrated security=true;" providername="system.data.sqlclient" />

i have sql server 2008 instance on local machine , domain username in "sysadmin" role.

i tried various database initializers , same error all. failing on first query call, code first not create database. can point connection string re-create of old database (before changes) , run fine, except old schema though specified dropcreatedatabasealways initializer. not making sense, , not next experienced on home machine working code first.

using visual studio 2012 , ef5.

i need able have code first generate new database. going on?

found out had static constructor in dbcontext class, overriding database initializer.

static mydbcontext() { database.setinitializer<mydbcontext>(null); }

code first reverse engineer set in don't overwrite existing database. when switched wasn't thinking it.

hope help else out.

entity-framework ef-code-first entity-framework-5

Comments

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

Accessing MATLAB's unicode strings from C -

javascript - mongodb won't find my schema method in nested container -