Edmx POCO files

Nov 7, 2013 at 8:30 AM
hi
I see that for the EDMX file generated in the data project , the simple POCO class Leaves.cs does not exist in the same folder but its referencecing the Leaves.cs in the Entities project . Is that correct ?

How can i achieve the same for a new class edmx i want to create ?
Coordinator
Nov 11, 2013 at 11:27 PM
Hi,

Yes. Both the Entities and Data project are separated.

You can create the entities manually for the Entities project and then delete any generated code from the EDMX in Data project.

Hugs,
Serena
Jan 21, 2014 at 12:39 AM
Edited Jan 21, 2014 at 1:15 AM
How did you get his work?

In my own project, vs2012 with EF 6.0.2, when I delete the generated code as you said, create POCO in Entities project, I always get an error:

In BookDAC.class,

public IEnumerable<Book> SelectAll()
    {
        using (var db = new DbContext(CONNECTION_NAME))
        {
            var q = db.Set<Book>();
            return q.ToList();
        }

    }
where Book is POCO class resides in seperated Entities project ,which is generated by Inertia.

namespace Sample.Entities
{
/// <summary>
/// Represents a row of Book data.
/// </summary>
[DataContract]
public partial class Book
{
    /// <summary>
    /// Gets or sets a int value for the id column.
    /// </summary>
    [DataMember]
    [Browsable(false)]
    public int id { get; set; }

    /// <summary>
    /// Gets or sets a string value for the name column.
    /// </summary>
    [DataMember]
    public string title { get; set; }

    /// <summary>
    /// Gets or sets a string value for the moniker column.
    /// </summary>
    [DataMember]
    public string author { get; set; }
}
}

System.InvalidOperationException was unhandled by user code
HResult=-2146233079
Message=The entity type Book is not part of the model for the current context.
Source=EntityFramework
StackTrace:
   at System.Data.Entity.Internal.InternalContext.UpdateEntitySetMappingsForType(Type entityType)
   at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
   at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
   at System.Data.Entity.Internal.Linq.InternalSet`1.GetEnumerator()
   at System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Sample.Data.BookDAC.SelectAll() in d:\Sample\Data\Sample.Data\BookDAC.cs
   at Sample.Test.BookDACTest.TestSelect() in d:\Sample\Tests\Sample.Test\BookDACTest.cs
InnerException:
Coordinator
Jan 24, 2014 at 5:43 AM
Hi,

In your Sample.Data project, after you have added an ADO.NET Entity Data Model,
  1. delete all the .tt files i.e. SampleModel.Context.tt and SampleModel.tt. Just leave the designer.cs and edmx.diagram.
  2. code your POCOs in Sample.Entities and then make sure you "Add Reference" your Sample.Entities to your Sample.Data.
  3. code your DAC.
Hope it helps.

Hugs,
Serena
Dec 9, 2014 at 12:03 AM
Edited Dec 9, 2014 at 12:50 AM
Hi Serena.

I have the same problem, I deleted all .tt files and still get the error "The entity type Encontro is not part of the model for the current context."

My Project.Entities is referenced in Project.Data.

:(

UPDATE: The problem was in foreign key, I deleted the relationship in edmx file for test and worked!
I'll search for more details.

UPDATE 2: The problem was in differences between edmx model and POCO class.
Adding a property for my foreign class solve the problem.

Thanks for your work and samples Serena!
Jan 11, 2015 at 7:00 PM
Other people who have the same problem try to check the connection string .

Connection string sample:
<add name=DATABASEEntities"
connectionString="metadata=res://*/DATABASEModel.csdl|res://*/DATABASEModel.ssdl|res://*/DATABASEModel.msl;provider=System.Data.SqlClient;provider
connection string=&quot;
data source=(local)\SQLEXPRESS;
initial catalog=PRIVATEDB
;persist security info=True
;Trusted_Connection=True
;MultipleActiveResultSets=True
;App=EntityFramework&quot;"
providerName="System.Data.EntityClient" />
Hope it helps someone.