Entity Framework is quite a good product, but in my opinion still misses some point to be called an ORM. I must admit that I never used the 4.1 Code first in real project, but there are some stuff that still does not convince me when using EF. When I decide to use EF (and [...]
EF 4.1 is now in RC phase and as a NHibernate user I’m curious to check the fluent API to map entities to database. One of the feature that I and Andrea miss most is the possibility to map private properties with fluent interface. It seems strange to map private properties at once, but it [...]
Continue reading about Mapping private properties with EF 4.1 RC and Fluent mapping
I really believe that I could not live anymore without ORM, and this is one simple reason. Suppose in NorthWind you should query for all Customers that have at least four orders where the total discount is greater than 100. Figure1: LINQ query to select all customers that have at least three orders with total [...]
Data Transfer Objects, best known as Dto, are an essential part of projects that uses services or Domain Model. Dto are great, but the disadvantage is that maintaining Dto objects is a pain, because they are composed by repetitive code, and you have no fun in writing them. Since building a Dto is a mechanical [...]
Continue reading about A dto factory code generator with visual studio T4
Suppose you need to paginate and letting the user choose the sort field in entity framework, lets see how you can accomplish this. In EntityFramework you can query with E-SQL both building a query in string format, but also using standard method syntax, here is an example (based on NorthWind) var query = context.Customers .OrderBy(“it.ContactTitle”); [...]
Continue reading about Entity Framework, dynamic sorting and pagination
