How to use ef6.exe

How do I generate an EF6 database with migrations enabled, without using update-database?

In EF5, I relied on the fact that I could recreate my database from the model using ...Database.CreateIfNotExists()...I would generate Migrations as needed, but never check them in to source control (since they tended to be artifacts of the development cycle) Each developer would then delete and recreate their own databases, from the model as nee...

Invalid object name 'dbo.__MigrationHistory' using Database.Create; EF6.02 when connection string is passed in

This happens because EF does some probing for the __MigrationsHistory table. For instance you can use EF with an existing database that was not created using EF Migrations but EF has no way of knowing it so it tries to connect to the database and uses the table to check this. If the table does not exist an exception will be thrown. EF then catches ...

Storing DateTime property instead of byte array in SQL table using Code-First MVC5 EF6

When I try to initialize my database using EF6 in MVC5 I get the error: ...The property 'Timestamp' is not a Byte array. IsRowVersion can only be configured for Byte array properties.... Is there a way I can override the IsRowVersion using FluentAPI or is there another method to store DateTime using MVC5 EF6 or is this simply the result of using th...

Is it possible to configure a custom provider for migrate.exe without using the machine.config

I could not find another way to configure migrate.exe to use a custom provider....The better solution in the end was to add a database initialiser into the applications entity framework configuration that will run the migrations automatically, instead of using migrate.exe....<entityFramework> <contexts> <context type="Assembly.ApplicationDbCo...

Can't run code first migrations using migrate.exe

Finally got this to work with Entity framework 6.1.3. I'm not sure if the version really matters, but we ended up downloading the code and debugging against that. ...What really made the difference was using the full path in both of the paths required... Hope that can help someone!...migrate CodeFirst.dll Configuration /startUpDirectory:"C:\src...

Moq & EF6 - Mocking EF6 Remove method not removing an object

I am trying to mock my EF6 ...DbContext... and it all works for ...Add..., ...Update..., ...Find... methods. But it's not working for ...Remove... method for unknown reason....In theory, after removing, the ...Students... collection should have only 1 return left. But it keeps returning the Count - 2....I put 3 Moq....Verify... checks to ensure t...

UnintentionalCodeFirstException | Entity Framework Unit Testing with Effort.Ef6 using Database First

The situation...I want to enable unit testing of my ...DbContext... based on entity framework 6. I have created my ...DbContext... and my models with the database first approach and now have an ....edmx... designer file....The problem...My automatically created ...DbContext... does override the ...DbContext.OnModelCreating... method like this:...pr...

How to generate .edmx.diagram file using edmgen.exe?

Using the suggestion provided in ...GitHub..., I was able to generate the EDMX files needed for an ASP.net project. Using a command like:..."%windir%\Microsoft.NET\Framework\v4.0.30319\edmgen.exe" /mode:fullgeneration /c:"Data Source=%datasourceserver%; Initial Catalog=School; Integrated Security=SSPI" /project:School /entitycontainer:SchoolE...

Using an ASP.Net Core 2 Web App to call Full a library using EF6

I'm trying a call a .Net 4.7 data access library (which uses Entity Framework 6) from a new Asp Net Core 2.0 Web Application....The issue is that EF6 can't seem to get hold of a DbProviderFactory. My working theory is that this is something that should be provided in the app/web.config of the calling program. The error that I'me getting is:...Sys...

Entity Framework 6.4 missing migrate.exe

I might just be completely out of date but I updated EF to 6.4 using nuget and I don't see migrate.exe in the tools folder anymore. Is there a change to run migrations? Or do I need to install another package for it? Appreciate any help. Thanks!