I have an ASP.NET application that uses a layered architecture e.g. presentation layer, business logic layer, data access layer.
I don't want to the business layer to have to know anything about how the data access layer is implemented and I'm not looking to bind the Entity's directly to a data control using the EntityDataSource or anything like that. (so a repository pattern scenario)
I'M JUST LOOKING TO USE THE ENTITY FRAMEWORK AS AN ORM TOOL TO GENERATE CLASSES. I know how to do this. What I'm not clear on is
- Is it advisable to propagate these classes up through the application so the business logic layer would be dealing with the partial classes created directly by the entity framework? (for instance if I have a customer table in sql, the entity fw would created a customer class which could potentially be used directly in all layers of my app)
- How to manage transaction support if my BLL is calling several different entity classes but wants to treat it as one transaction
I suspect that this may be the answer to your problem:
http://code.msdn.microsoft.com/EFPocoAdapter/Release/ProjectReleases.aspx?ReleaseId=1580
The tool generates classes that have no entity framework dependency that you can pass across tiers.
Another way to do this is to use mapper classes, use what EF purely as data access and use the classes EF generated only within the DAL, then map these DAL objects to your BLL's objects through mappers. It works fine for us.
Now with the new EF4 you can also use POCO classes, thus removing the extra load of mapping the entities between layers. In our application we used EF4 and used business entities across the application other than view which required viewmodel. It gave significant performance boost.
Not with entity framework, but I had tried to create a sample with two insert stored procedures being executed separately in the data access layer(using data access application block 3.1), wrapped inside TransactionScope context in Service/BLL, it did not work. One insert passed, other one failed and data WAS commited.
Did you have any success doing this yourself?
Even if you use generated POCO classes, like the other ops are suggesting, you will still have to maintain a certain dependency to entity framework: the queries that you send to your DbContext / ObjectContext. Therefore you should consider encapsulating the queries in repositories.