Entity Framework 6 - Knowledge Base (KB)
19 results in tag: localdb
Is Visual Studio 2010 compatible with Entity Framework 5's LocalDB?
Is LocalDB supported by Visual Studio 2010 in Entity Framework 5, on .NET 4.0?...Or am I doing it wrong? I'm getting a "The network path can't be found" issue when instantiating my model container with a connection string for LocalDB....Here's the connect...
asked by Mathias Lykkegaard Lorenzen
Reset EF code-first database in LocalDB
I am using Entity Framework 5.0 RC with the LocalDB database that comes pre-configured with VS 2012 RC for some prototyping and testing of code-first database....After a few cycles of changing my code-first database and running "update-database" I did a h...
asked by angularsen
Can I specify the filename for a localdb database in entity framework 5?
If I'm using Entity Framework 5 with LocalDb, is there a way of specifying the filename of the database in the app.config/web.config file?
asked by Nick Randell
Change default location of LocalDb
I am programming with EF5-code first and want to use LocalDb. How can I change the default location of LocalDb database file? Default location is %USERPROFILE% directory according to ...http://blogs.msdn.com/b/sqlexpress/archive/2011/10/28/localdb-where-i...
asked by Hoss
Recreate and Reseed LocalDb Before Each Unit Test
I'm attempting to write unit/integration tests for my ASP.NET Web API project and struggling to run each test in isolation. Allow me to explain....I have a *.testsettings file with deployment settings configured. Before each test run, an empty *.mdf fil...
asked by Raymond Saltrelli
Unable to generate explicit migration (EF5) (migrations pending)
We are using Code-first migrations with EF5 on (localdb)\v11.0 (Vstudio 2012) and everything has worked nicely so far....However - today I needed to create a couple of indexes on a few of tables and ran into problems....First I did this in PM:...PM> add-m...
asked by Jesper Lund Stocholm
Cannot attach the file as database / The underlying provider failed on Open
I have an MVC3 application using the Entity Framework. I haven't used this application in about a year. Recently, I opened it up on a new PC and tried to run in debug mode and hit the following exception/stack trace in debug. The main exceptions seem t...
asked by DanJosef
How to connect to LocalDB in Visual Studio Server Explorer?
I can't believe I couldn't find a working solution to this after an hour of searching. I'm following ...this article... on Entity Framework 6.0 which gives a simple walk-through on Code First. I created the project and installed the latest ...EF Nuget pac...
asked by orad
EF6 migrations (LocalDb) update-database login failed
VS 2013 MVC5 code first project....I’m working through the ASP.NET ...Getting Started with EF6 using MVC5... tutorial to get up to speed on the latest changes and I’m having a problem with migrations. In the first module the database is created using ...
asked by Joe
LocalDB database on fly for entity framework code first
is possible to create an mdf file on fly (at runtime) and use it with entity framework 6 in a code first approach?...I need something like this:...if (mydb.mdf not exists) createmdf(); mycontext ctx = new mycontext(mydb.mdf connection string) ctx.Cre...
asked by LoxLox
System.Data.DataException error occurred in EntityFramework.dll
I have been following this tutorial ...Getting Started with Entity Framework 6 Code First using MVC 5.......When I got to the section where I need to run the program and click on Student so that the program would create database I get the following error....
asked by Pheap
Code-First approach, location of database and all instances (v110, etc)
I'm following this ...tutorial... to create a Code-First Database.... After installing EF and creating those first basic classes it says:...Run your application and you will see that a MigrationsCodeDemo.BlogContext database is created for you....Well, ...
asked by QuantumHive
How to RESEED LocalDB Table using Entity Framework?
Is There any way to ...RESEED... a ...LocalDB... Table using EF?...I'd prefer not to use this SQL Command :...DBCC CHECKIDENT('TableName', RESEED, 0) ...FYI : I'm using EF 6.1....Thanks alot.
asked by Mahdi Rashidi
How to define DataDirectory for ConnectionString in console application to work with EntityFramework Code First Migrations
I try to set location ...MyProject\App_Data\Cos.mdf... for the database in ...App.config...:... <connectionStrings> <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\Cos.mdf;Initial Catalog=Co...
asked by Yoda
EF6 localdb for integration testing
I am developing a WPF application which requires some database access. For development purposes I am using localdb with database migrations enabled and EF6....What I cannot figure out is how do I configure a separate localdb database for integration tests...
asked by Alan Rutter
LocalDB instance specified does not exist
I am trying to build an ASP.NET MVC 5 Web Application in SQL Server 2015 Express using EntityFramework 6 but when I debug the application and go to a page where the database is needed I get the following error....System.Data.SqlClient.SqlException was unh...
asked by Alexandra
Add a localdb for tests
I use entity framework 6 code first. ...At the moment I have a database for production. I want to add a different database for tests. How do I do that? ...Do I need another connection string in my tests project? ...What should be the difference between t...
asked by user5326354
ASP .NET Entity Framework Database not initialized
I have created an ASP .NET MVC application with simple login and sign up functionality, and am trying to create an Entity Framework 6 model using Code First Approach. I am using LocalDb to create the database. However, I get the following exception when I...
asked by C. Lee
Prevent update of MDF file when attaching to newer version of LocalDb
I have WinForms app using EF6. The app use ...LocalDb... storage (2014) because I need it to work from Windows 7 to the Windows 10. ...And it is delivered with a ....mdf... file in app folder, and attaching it via connection string. ...When I attach the ....
asked by BabaYaga
