Entity Framework Power Tools Beta 3

by Arunima K R | May 13 2013

Need an option to select the tables for which the mapping and entities has to be generated. Now it is bringing up all the tables.

by techtalk77 | April 08 2013

There is a bug with these tools in VS 2012 right click DbContext > Entity Framework > View Entity Data Model only works if the full connection string is specified. Simply the name of the connection string does not work. This may be a consequence of my EDM being in a separate project. Please fix this bug.

public partial class UnityDbContext : DbContext
{
public UnityDbContext()
: base("Server=...full connection string...") //Works
//: base("Name=UnityDbContext") //Not works
{
...
}

by DoWorkAync | March 31 2013

I was initially excited to discover this tool while watching a Julier Lerman video but when I tried to "View Entity Data Model", I got a cryptic VS error "sequence contains no matching element" :-(

by TrumanCode | March 23 2013

Rowan, I'm sure you guys are well aware of this but EF Power Tools Beta 3 in VS 2012 does not reverse engineer SQL Compact databases. Is this bug going to fixed in the next revision?

The error is:

System.ArgumentException:

The modelEntityContainerName parameter 'C:\XXXX\XXXXContext' contains characters that are not valid.
at XXXsdfConteSystem.Data.Entity.Design.EntityModelSchemaGenerator.Initialize(EntityContainer storeEntityContainer, IEnumerable`1 storeFunctions, String namespaceName, String modelEntityContainerName)
at System.Data.Entity.Design.EntityModelSchemaGenerator..ctor(EntityContainer storeEntityContainer, String namespaceName, String modelEntityContainerName)
at Microsoft.DbContextPackage.Handlers.ReverseEngineerCodeFirstHandler.ReverseEngineerCodeFirst(Project project)

by lazyberezovsky | February 28 2013

Reverse engineering works fine, but Data Model viewing fails with "Sequence contains no elements". My context is inherited directly from DbContext, and it has default constructor. VS2010, EF5.

by CharlesLZ | February 15 2013

Reverse engineering feature does not honor cascade delete settings for foreign keys.

If FK1 has Delete Rule set to No Action in SQL Server, the following mapping is generated.

this.HasRequired(t => t.Entity)
.WithMany(t => t.RelatedEntities)
.HasForeignKey(d => d.EntityId);

This implies delete on cascade which goes against what the database was originally designed to do. It should be generating the following...

this.HasRequired(t => t.Entity)
.WithMany(t => t.RelatedEntities)
.HasForeignKey(d => d.EntityId)
.WillCascadeOnDelete(false);

Otherwise, the tool has worked out great so far.

**UPDATE

I was able to resolve the issue above by customizing the t4 templates. You can determine if the FK is set to cascade via navProperty.ToEndMember.DeleteBehavior == System.Data.Metadata.Edm.OperationAction.Cascade

by Kevin Cefalu | February 08 2013

Got this error when attempting to update to the latest release. Any solutions?

02/07/13 16:31:28 - Install Error : VSIXInstaller.SignatureMismatchException: The signature on the update version of 'Entity Framework Power Tools Beta 2' does not match the signature on the installed version. Therefore, Extension Manager cannot install the update.
at VSIXInstaller.Common.VerifyMatchingExtensionSignatures(IInstalledExtension installedExtension, IInstallableExtension updateExtension)
at VSIXInstaller.InstallProgressPage.BeginInstallVSIX(SupportedVSSKU targetAppID)

by Maxkn1 | February 05 2013

Generate Views does not work.
Tested on this simple case:

public class TestContext :DbContext
{
public TestContext() {}
public DbSet<TestModel> TM { get; set; }
}

public class TestModel
{
public long Id { get; set; }
public string Name { get; set; }
}

Every time got the "Sequence contains no matching element" error message


Microsoft Visual Studio Ultimate 2012
Version 11.0.51106.01 Update 1
Microsoft .NET Framework
Version 4.5.50709

by xiaozhuang | February 01 2013

Does anyone know how to get column extend Properties in Entity.tt ? e.g. Column Description?

by horrorace | January 30 2013

This was working excellently for me but recently I have been getting the error below when doing a reverse engineer. I have been pulling my hair out trying to work out what's going wrong. The same solution works on my coworkers machines when doing the same thing so it must be something wrong on my Visual Studio.

One or more errors occurred while processing template 'Entity.tt'.
CodeTemplates\ReverseEngineerCodeFirst\Entity.tt(2,4) : error : There was an error loading the include file 'EF.Utility.CS.ttinclude'. The transformation will not be run. The following Exception was thrown:
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.DbContextPackage.Utilities.EfTextTemplateHost.Microsoft.VisualStudio.TextTemplating.ITextTemplatingEngineHost.LoadIncludeText(String requestFileName, String& content, String& location)
at Microsoft.VisualStudio.TextTemplating.Engine.ProcessIncludeDirective(Directive directive, ITextTemplatingEngineHost host)