This missing feature seems to annoy a lot of people. Good news: MS will address the issue with .NET 4.0. Bad news: for now, or if you’re stuck on 3.5 you have to do a little bit of work, but it IS possible. You have to do it like this: Locker locker = new Locker(); … Read more
Based on C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\Extensions\Microsoft\Entity Framework Tools\Templates\Includes\EF6.Utility.CS.ttinclude , the code generator is looking for the missing DLLs in the following locations: <#@ assembly name=”%VS120COMNTOOLS%..\IDE\EntityFramework.dll” #> <#@ assembly name=”%VS120COMNTOOLS%..\IDE\Microsoft.Data.Entity.Design.dll” #> I discovered that the environment variable %VS120COMNTOOLS% is not compatible with the correct installation path of visual studio, so I changed it from … Read more
OK, much too many hours later I found the solution myself: Option 1: It is possible to use the select property in the EntityDataSource which allows to create arbitrary projections of data from several related entities/database tables (in my case: OrderID from Order entity and City from the Address entity) Drawback: Using select in the … Read more
Having one big EDM containing all the entities generally is NOT a good practice and is not recommended. Using one large EDM will cause several issues such as: Performance Issue in Metadata Load Times: As the size of the schema files increase, the time it takes to parse and create an in-memory model for this … Read more
Go to “C:\ProgramData\Package Cache” and search for “EFTools.msi”. You should find two files, just install the most recent one (it should be about 960KB). This fixed the problem for me.
Setting this property to Computed is telling EF that you cannot set the value directly. How could you? This property exists for the sake of computed columns, which by definition are not saved back to the database. Unfortunately, EF’s “Default Value” property can only be set to values known at compile-time, and so not DateTime.Now … Read more
If it were me (when it is me…): You don’t particularly want to be trying to make database files work by copying them and attaching them – there are reasons why you might want to but I believe these to be exceptions rather than rules. Accordingly what you need to do is to script creation … Read more
I just had the same situation when trying to configure Visual Studio Professional 2017 environment with MySQL, ADO.NET (Database First) and EF6. Note: Please follow steps in the same order. Uninstall/remove “Connector/NET” and “MySQL for Visual Studio” if installed. Install “MySQL for Visual Studio” v2.0.5 CTP (MySQL for Visual Studio). Note: Install MySQL for Visual … Read more