Newer version (the real EF5) is dependent on .NET 4.5. If you have added EF5 when your project was based on .NET 4.0 you will have only EF 4.4 (EF5 version without features dependent on .NET 4.5). After upgrading to EF 5.0 you need to update EntityFramework package. You can try to use Update-Package command. … Read more
int[] ids = new int[]{1,2,3,45,99}; using (DatabaseEntities db = new DatabaseEntities ()) { return db.Licenses.Where( i => i.license == mylicense && ids.Contains(i.number) ).ToList(); } should work
There are two open source projects allowing this: EntityFramework.Extended and Entity Framework Extensions. You can also check discussion about bulk updates on EF’s codeplex site. Inserting 100k records through EF is in the first place wrong application architecture. You should choose different lightweight technology for data imports. Even EF’s internal operation with such big record … Read more
I noticed in visual studio, going to SQL menu, Transact-SQL Editor, New Query… gave a dialog about the tools not working with the server installed. Installing SQL Server Data Tools – December 2012 update (Sql Server Data Tools) fixed the problem
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
Oh wow, nevermind. I’m dumb. In the Nuget package manager console there is a dropdown menu at the top labeled “Default Project:”. Make sure you set that to the project you want to run the command against. Hopefully this helps someone else avoid my embarrassing mistake.
update-database -verbose doesn’t work because your model has been changed after your data table already existed. First, make sure there are no changes to the UserProfile class. Then, run: Add-Migration InitialMigrations -IgnoreChanges This should generate a blank “InitialMigration” file. Now, add any desired changes to the UserProfile class. Once changes are added, run the update … Read more
You should create edmx model first to generate POCO’s from it automatically. You can add it through menu (Add New Item -> ADO.NET Entity Data Model). After the model will be created you can use the DbContext generator. Replace $edmxInputFile$ with the name of your edmx file and then save file you are edit (though … Read more
The EDMX file is an XML file that is a combination of 3 different parts that make up the whole thing. If you right-click on your EDMX file and choose “Open with… XML Editor” you’ll see the 3 different sections: <edmx:ConceptualModels> <edmx:StorageModels> <edmx:Mappings> These sections can be edited manually, at your own risk! 🙂 That … Read more
The smartest way is probably to not alter types. If you need to do this, I’d suggest you to do the following steps: Add a new column with your new type Use Sql() to take over the data from the original column using an update statement Remove the old column Rename the new column This … Read more