Hi all, We're trying to decide if it's worth using entity framework 4 on a project. To that end, I think a good place to start would be by comparing it to nhibernate, which is mature and proven by years of use to have all the features people need for enterprisey apps, and find out what features nHibernate has that EF4 is missing out on....
I'm using Entity Framework behind a set of repositories. The repositories use DTOs instead of the entity objects generated by the Entity Framework. I'm using AutoMapper to convert them back and forth. I'm having trouble figuring out how to do the following: Method definition: public IEnumerable<DTO.User> Get(Func<DTO.User, bool> where...
Best way to show the SQL trace of a LINQ query to Entity Framework 3.5? I am using ASP.net and EF 3.5. Dim dbo As Web.Portal.RBMEntities = New Web.Portal.RBMEntities Dim Query = From RoleAllocations In dbo.RoleAllocations Where RoleAllocations.user_id = _ID And RoleAllocations.expire_date > Today Select RoleAllocations ' Console writ...
Hi, We have an ASP.NET MVC site that uses Entity Framework abstractions with Repository and UnitOfWork patterns. What I'm wondering is how others have implemented navigation of complex object graphs with these patterns. Let me give an example from one of our controllers: var model = new EligibilityViewModel { Country = pers...
I have a Linq extension method to dynamically filter Linq queries using string values. For example: query.WhereHelper("columName", ">", 1). I could use many different filter operators like GreaterThan or NotEqual etc. but not "Like". There is no Expression.Like or Expression.StartsWith etc. How can I implement Like operator to my Express...
Hi, i want apply my linq query with 3 table joined to EntityDataSource at codebehind,I found this link but i want use 3 table http://msdn.microsoft.com/en-us/library/ee404748.aspx ...
Hi, does anyone know if is possible to add 2 entities into EF model from 2 DB. If not, what suggestions can you gave me to build a query that affects 2 databases ...
I need lightweight database for an ASP.NET MVC application. would prefer not to install anything additional on the host box would also prefer being a little more robust than XML would like to use activerecord or entity frameworks ...
I can't seem to update my database from disconnected poco objects. In this example, I fetch an ApplicationUser object, update varchar(100) field SSOID, but no changes take effect. Even when I refetch the object in the save method, nothing gets sent to the db. If I try to call ApplyCurrentValues, it throws An object with a key that m...
We have an Entity Framework model that is used by two different silverlight applications. The validation rules are very similar in the two contexts, but differ slightly. For example, a regular user in one of the applications cannot input time that is in the future, but an administrator in the other application can put time that is in...
I asked this question a while back without an answer, I believe it may be the most bizarre implementation for the EF, although it is quite practical. Here is my previous post: http://stackoverflow.com/questions/2367702/entity-framework-self-referencing-hierarchical-many-to-many I've decided to ask again with the additional keyword Payl...
Hey, I am pretty certain I am doing something incorrectly with my lambda expression and that is making it so that I only return a single result. If there is nothing wrong with my query (it has the ability to return multiple results), then I must have an error elsewhere and I should be able to find it. If my results should return more tha...
Hi, i've been using Nhibernate with LINQ a fair bit now and i have a few issues. Say i have the following entities: public class User { public virtual int UserID { get; set; } public virtual bool IsActive { get; set; } public virtual bool SomeField { get { return 0; } } public virtual DateTime DateRegistered { get; set;...
I am trying to get the functionality of SQL servers MERGE statement in Entity Framework. At a WCF service, I am receiving a list of records from a client app. I want to compare a particular field in ALL the records in the list against a database table. -Should there be a matching record in the db, I need to update the other fields in t...
I getting the following when I try to "test" this WCF: *This operation is not supported in the wcf test client because it uses type MFA_WCF.gridObj()* I should note that this is my 1st attempt to learn WCF and I'm also still learning EF. So I'm sure this is something I did. I'm just wondering if someone can tell me what I'm doing inc...
I need to translate the following LINQ query to Dynamic LINQ that accepts several grouping columns based on user input. Basically I have a bunch of dropdownlists that apply groupings and I don't want to enumerate every combination of groupings. If Dynamic LINQ fails, I may have to construct a SQL query manually, and nobody wants that. ...
Hi, I am trying to build a dynamic predicate with Entity Framework by mapping an enum to the column field: In the where clause i have entered ?? as i am not sure what to put there, i want this be dynamic like in this article, although that doesn't work me in EF on;y linq to sql: http://stackoverflow.com/questions/2497303/how-to-specif...
My Question is can we extend one context to another in Entity Framework 4. Following is the problem background. I am using EF4 for developing a Web-Application. My Web Application has 3 projects. One project is for storing candidate CV information. Another project is for storing customer information. Final project is called CORE. t...
Hi All, I have a simple Web Form where I've dragged a FormView and dragged an EntityDataSource onto my page. The page shows a single contact with all tags associated with it. I can't seem to get the related tags of a contact to display in a gridview. For a picture of what I'm talking about click -> here Please state exact steps becaus...
I need to execute a SQL stored procedure every time before I query my ObjectContext. What I want to achieve is setting the CONTEXT_INFO to a value which will be later on used with most of my queries. Has anyone done that? Is that possible? [EDIT] Currently I'm achieving this by opening the connection and executing the stored procedure...