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
Post a Comment