EF 6 as far as I know introduced the .RemoveRange() option on your DbContext. So in short, you can do something like the following: var db = new MyDbContext(); var itemsToDelete = db.MyTable.Where(x=>!x.active); db.MyTable.RemoveRange(itemsToDelete); db.SaveChanges(); So instead of having to do any type of foreach, you can utilize this new extension method. With your Unit … Read more
I think your problem is, that your T4 templates, which generate the entitties and the context are still in EF version 5. First you have to delete the current code generation items, which are in the code behind of the model, namely <Modelname>.Context.tt and <Modelname>.tt.Next add a new EF version 6 code generator with Right … Read more
You can overcome this scenario by replacing: using System.Data.Objects; With: using System.Data.Entity.Core.Objects; You may need to update the using statements in your T4 templates, like your Context.tt file, so that auto-generated files continue to work when re-generating. Before After
I solved same error with just add a single line in App.config <provider invariantName=”System.Data.SQLite” type=”System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6″/> PS: Add provider to <configuration> > <entityFramework> > <providers>
If you find as I did that EF is not installed in the Gac then the next step is to uninstall it AFTER you note the version of your package. I use NuGet so I went to Tools…Library Package Manager…Package Manager Console. I tried the GUI first but uninstalling failed and as of this writing … Read more
First of all, we don’t even need to install the mysql-installer-community-5.7.3.0-m13.msi. Install the latest mysql-visualstudio-plugin Install the latest mysql-connector-net New C# .Net 4.5 Framework WinForms (for 4.0 it should work based on Does Entity Framework 6 support .NET 4.0? ) Install 4 Nuget Packages (follow sequence, if you install Mysql.Data.Entities before EntityFramework, it will resolve … Read more
What @emcas88 is trying to say is that EF will only check the cache when you use the .Find method on DbSet. Using .Single, .First, .Where, etc will not cache the results unless you are using second-level caching.
Based on this answer by DaveD, these steps address the issue: In your .edmx, rt-click and select Model Browser. Within the Model Browser (in VS 2015 default configuration, it is a tab within the Solution Explorer), expand Function Imports under the model. Double-click your stored procedure. Click the Update button next to Returns a Collection … Read more
Just thought I’d share another way to configure EF6 with SQLite without using app.config / web.config. EF6 now supports code based configurations as outlined here on msdn. I used the following code (updated to remove reflection thanks to Sly): public class SQLiteConfiguration : DbConfiguration { public SQLiteConfiguration() { SetProviderFactory(“System.Data.SQLite”, SQLiteFactory.Instance); SetProviderFactory(“System.Data.SQLite.EF6”, SQLiteProviderFactory.Instance); SetProviderServices(“System.Data.SQLite”, (DbProviderServices)SQLiteProviderFactory.Instance.GetService(typeof(DbProviderServices))); } … Read more
You delete your old .tt files You open your edmx file in designer mode (so you can see your model) Right click on a free space Select Add Code Generation Item In the dialog select “EF 6.x DbContext Code Generation Item” (something like this) Save your edmx and all classes will be generated for you, … Read more