CODEWITHSUNDEEP
c#.netsql-serverentity-framework
Carvellis
Carvellis

Reputation: 4052

Can't have the same table names in different entity framework models?

My application uses two different SQL 2008 databases. The databases have a few tables with the same name, ie. Users. I would like to use EF4 for both these databases. However, when I run my application and it hits the objectcontext creation of the second database, I get the following error:

Multiple types with the name 'User' exist in the EdmItemCollection in different namespaces. Convention based mapping requires unique names without regard to namespace in the EdmItemCollectionto namespace in the EdmItemCollection

Does this mean I can't use two databases with (partly) the same table names in the same application? They are in different namespaces, different edmx models, different projects, etc.

P.S. One of the models is designer-generated and uses POCO classes and the other is inferred from the database and is tightly coupled to EF.

Upvotes: 17

Views: 12535

Answers (5)

George
George

Reputation: 43

For DB first approach, Luckily there are couple of workarounds which are pretty straightforward:

  1. Make sure that that both contexts don't share tables with the same name - not the most practical approach.
  2. Restructure the solution by isolating the database contexts within their own assemblies.

For more detail, please refer this link

Explained very clearly.

Upvotes: 0

Juan
Juan

Reputation: 441

Another reason for that error is what happened to me: My project was copied from somewhere else and I renamed the project, so after compiling there were 2 DLL's in my bin folder. The one from the previous project and a brand new one, named according to the new project. Once I deleted the previous/old DLL the namespace ambiguity disappeared and the error went away.

Upvotes: 0

Leblanc Meneses
Leblanc Meneses

Reputation: 3091

To use the "default convention based mapping" the following 2 approaches will work:

1) The collision is caused by the connection string using a wild card:

    metadata=res://*/Repositories.EntityFramework.Model.csdl|res://*/Repositories.EntityFramework.Model.ssdl|res://*/Repositories.EntityFramework.Model.msl;

Since * does not work your project you can define multiple connection strings to hard code the assembly containing the edmx.

2) create a helper

    public static EntityConnection GetEfConnectionString(this string sqlConnectionString)
    {
        var cs = string.Format(@"metadata=res://{0}/Repositories.EntityFramework.Model.csdl|res://{0}/Repositories.EntityFramework.Model.ssdl|res://{0}/Repositories.EntityFramework.Model.msl;provider=System.Data.SqlClient;provider connection string=""" + sqlConnectionString + @"""",
            Assembly.GetCallingAssembly().FullName
        );

        return new EntityConnection(cs);
    }

Update 2017:

    public static string GetEfConnectionString(this string sqlConnectionString, Type type)
    {
        string cs =
            string.Format(
                @"metadata=res://{0}/Models.Model.csdl|res://{0}/Models.Model.ssdl|res://{0}/Models.Model.msl;provider=System.Data.SqlClient;provider connection string=""" +
                sqlConnectionString + @"""",
                type.Assembly.FullName
                );
        return cs;
    }


    // usage: don't "new" EntityConnection.  See 2012 comment.
    string connString = ConfigurationManager.ConnectionStrings["sqlConnection"].ConnectionString.GetEfConnectionString();
    using(var entities = new XyzEntities(connString))

Upvotes: 22

user3728728
user3728728

Reputation: 935

I had the same problem, but my solution was to delete the DLL of the MODEL\edmx from the project, because it was copied from a different project, and then rebuild it. Solved everything!

Upvotes: 1

Dirk Brockhaus
Dirk Brockhaus

Reputation: 5072

The error means, what he says: You can't use the default convention based mapping in your scenario. Use custom database mapping instead. Scott Guthrie has a detailed blog item about this.

Upvotes: 10

Related Questions