Just use AutoMapper. Example: Mapper.CreateMap<Address, AddressDTO>(); Mapper.CreateMap<Person, PersonDTO>(); Your query will execute when the mapping is performed but if there are fields in the entity that you’re not interested use Project().To<> which is available both for NHibernate and EntityFramework. It will effectively do a select on the fields specified in the mapping configurations.
I’m assuming C#. DateTime startDate=bla; DateTime endDate=blabla; using(var db=new MyDataContext()) { var filteredData=db.TABLE.Where(t => t.DATE > startDate && t.DATE < endDate); //… }
songs.UserSongs.GroupBy(x => x.User).Select(g => new SongsForUser() { User = g.Key, Songs = g.Select(s => s.SongId).ToList() });
http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/6529a35b-6629-44fb-8ea4-3a44d232d6b9/ var people = entities.People.Where(“it.Name LIKE @searchTerm”, new ObjectParameter(“searchTerm”, searchTerm));
The reason it is complaining is because it doesn’t know how to translate your Select() into a SQL expression. If you need to do a data transformation to a POCO that is not an entity, you should first get the relevant data from EF and then transform it to the POCO. In your case it … Read more
This is a guess, but I think your anonymous type might be attempting to duck-type to an enum when you’ve got more than two queries. If that’s happening, then you’ll get this complaint about not implementing IConvertible, as enum implements IConvertible, and your anonymous type (now derrived from enum) does not implement the interface.
In my case, the problem was that I stopped the application while debugging. The application was making a lot of async callings. So I reset my IIS server: iisreset via Command Prompt or PowerShell, and it worked. EDIT: Look at the @aaroncatlin comment for IIS Express
As you are selecting the property, just get the value of the nullable: List<int> lst = Orders.Where(u => u.SplOrderID != null) .Select(u => u.SplOrderID.Value) .ToList();
You can write it using two from expressions like below: from a in Table1s from b in Table2s where a.ID1Table1 == b.ID1Table2 && a.ID2Table1 == b.ID2Table2 select new {a.ID1Table1, a.ID2Table1, a.Value1Table1, b.ID3Table2, b.Value1Table2} Using join: from a in Table1s join b in Table2s on new{PropertyName1 = a.ID1Table1, PropertyName2 = a.ID2Table1} equals new{PropertyName1 = b.ID1Table2, PropertyName2 … Read more
The .Any() extension method typically maps to exists.