Preview of useful design-time features for DbContext.
When right-clicking on a C# project, the following context menu function is supported:
1) Reverse Engineer Code First - Generates POCO classes, derived DbContext and Code First mapping for an existing database.
When righ...
I've installed Beta 2 on a Windows 7 64-bit machine with Visual Studio 2010 SP1 and SQL Server 2012. After installation, the Server Explorer couldn't connect to the database, complaining that only versions up to SQL Server 2008 are supported.
Uninstalling PowerTools solved the problem, but left me without PowerTools...
Eugenio, I've same problem: System.InvalidOperationException: This operation requires a connection to the 'master' database. Unable to create a connection to the 'master' database because the original database connection has been opened and credentials have been removed from the connection string. Supply an unopened connection. ---> System.Data.SqlClient.SqlException: Login failed for user 'sa'.
And I'm sure the Login info for 'sa' is correct, because in connection wizard, Test Connection is OK.
UPDATE ----------------- found the solution here: http://stackoverflow.com/questions/4324052/ef4-code-first-causes-invalidoperationexception
In connection wizard, Advanced should be clicked and the value of Persist Security Info should be True.
I am getting "Sequence contains no matching element" on click of "Generate Views" menu of Entity framework power tool (Beta 2). I am using Visual studio 2010 (premium) and entity framework 4.4
System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.DbContextPackage.Extensions.ProjectExtensions.InstallPackage(Project project, String packageId) at Microsoft.DbContextPackage.Handlers.ReverseEngineerCodeFirstHandler.ReverseEngineerCodeFirst(Project project)
One or more errors occurred while processing template 'Mapping.tt'. error : Running transformation: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.VisualStudio.TextTemplatingf34e03996f2d4022aad496a20b3137d6.GeneratedTextTransformation.TransformText() at Microsoft.VisualStudio.TextTemplating.TransformationRunner.RunTransformation(TemplateProcessingSession session, String source, ITextTemplatingEngineHost host, String& result)
Hi, I am using Visual Studio 2010 and MySql 5.5. When i use the reverse engineer code first function, it always report errors, even i reverse the database with only one empty table. The exception below always appears. Is this tool support MySql? Can you give me some help? Thank you in advance.
One or more errors occurred while processing template 'Mapping.tt'. error : Running transformation: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.VisualStudio.TextTemplatingd98a42fc59ce43d99d01869c2b137080.GeneratedTextTransformation.TransformText() at Microsoft.VisualStudio.TextTemplating.TransformationRunner.RunTransformation(TemplateProcessingSession session, String source, ITextTemplatingEngineHost host, String& result)
Hello, I am new with EF, and I like it. However, I was surprised that EF PowerTools work just with C# (and not with VB). Are there any plans to correct that?
System.Data.ProviderIncompatibleException: The provider did not return a ProviderManifestToken string. ---> System.InvalidOperationException: This operation requires a connection to the 'master' database. Unable to create a connection to the 'master' database because the original database connection has been opened and credentials have been removed from the connection string. Supply an unopened connection. ---> System.Data.SqlClient.SqlException: Login failed for user 'sa'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) ...
is there anyone else getting the same error? I'm not using a local db engine by the way, I'm using a server over the network.
this tools seems very useful and sounds like there are a lot of ppl using it. i haven't tried it out yet because it is in beta form. are there plans to release this as a final release version?
(1) How to customize the generated folder structure? I dont want folder like /Models/Mapping.
(2) Please escape property name in mapping files. (I have "New" column name that I cant change the db schema). In the Entity.tt work nice but in the Mapping.tt at this line:
I am using AdventureWorks2012 with SQL Server 2012 Express and trying to create the entity. I am getting the below error
One or more errors occurred while loading schema information. error 6004: The table 'AdventureWorks.Production.Document' is referenced by a relationship, but cannot be found.
I received error when do"reverse engineer code first" command ."System.Data.ProviderIncompatibleException: The provider did not return a ProviderManifestToken string. ---> System.InvalidOperationException: This operation requires a connection to the 'master' database. Unable to create a connection to the 'master' database because the original database connection has been opened and credentials have been removed from the connection string. Supply an unopened connection. ---> System.Data.SqlClient.SqlException: Login failed for user 'sa'."