Entity Framework - Get Object as Collection
Is it possible to get a collection (Dictionary) out of an Entity Object? I need this in order to pass parts of the Properties of the object to a function that needs an IDictionary. ...
entity-framework
Building a stack in Entity Framework
One type of entity in my model (let's call it E1) needs to be able to treat its relationship with another entity type (E2) as a stack. Reciprocally, that other entity needs to be able to see all related entities of the first type where the E2 is at the top of the stack, and separately every case where the E2 is within a stack for an E1. ...
JS Framework incorporated with CruiseControl
Are there any JS Framework that can be incorporated with CruiseControl.NET ? Or what's the best JS Framework that have an intensive unit testing feature. ...
Entity Framework vs alternatives
Duplicate: What ORM frameworks for .NET Do You Like Best? What are you currently using for data access? When choosing an ORM, is LINQ to SQL or LINQ to Entities better than NHibernate? Database (and ORM) choice for an small-medium size .NET Application Etc. What OR\M would you recommend for a large ASP.NET application, Entity Framew...
forward mapping with ado.net entity framework
i'm experimenting the entity framework lately, i wonder is it possible to model entities in designer view from scratch then let the framework handle the schema creation, foreign keys and such automatically? ...
How to load varbinary(max) fields only when necessary with ADO.NET Entity Framework?
I have a varbinary(max) field in one of my tables but I don't need it every time and I'm looking for a way to fetch it from the database only when necessary. I'm using ADO.NET Entity Framework. How to do that? ...
ADO.NET Entity Framework: QUERY n-n relationships
Hi! I have four tables: Client with PK ClientID. Destination with PK DestinationID. Language with PK LanguageID. DestinationDetail with PK DestinationID. RL-Client-Destination with PKs ClientID and DestinationID. The Client may have zero or n Destinations. A destination has n DestinationDetails, each of these DestinationDetail has a...
Linq to entity with a big database
We are about to start a project which involves using a Sql Server 2005 with lakhs of records. In the past I have used NHibernate with good results. But now I am evaluating Linq to entity for the data access. I have these questions on L2E, How good is the caching that the L2E does compared to NHibernate (basically how is the performanc...
Bug in our SQL or Entity Framework?
Hi Guys, I have some SQL from our DBA which I'm just checking it is right, since the EF doesn't seem to fully link entities together. It knows there is a relation but doesn't perform the FK to PK link. Any ideas or thoughts (rather than use NHibernate! ) on it are appreciated. 1 CREATE TABLE [dbo].[Employee]( 2 [ID] [int] I...
Map entities to database with Entity Framework
Hello, I've made a quite big domain model with entity framework. I wanted to know if it is possible to map it so i create automaticly the tables in the database wanted? I've looked up edmgen.exe but still couldn't find the right command. thank's for helping! Edit1: I know the tool LightSpeed from Mindscape ofer this features that's w...
Saving many-to-many relationship objects in entity framework
I'm trying to save an entity that forms part of a many-to-many relationship in the entity framework and am getting the error: Unable to update the EntitySet 'zRM_OP_defaultloccvgsMapping' because it has a DefiningQuery and no element exists in the element to support the current operation. My google-fu is weak on this one, but I unders...
LinQ to Entities: Doing the opposite query
I wrote this: var destinations = db.DestinationDetails. Where(dd => dd.Language.Lang == "en-US" How can I retrieve destinationDetails that client with email [email protected] doesn't have? This doesn't work: var destinations = db.DestinationDetails. Where(dd => dd.Language.Lang == "en-US" Thanks! ...
Eager loading with Include()
Imagine this case: var locations = from Locations in this.LocationDataContext.Locations .Include("ChildLocations") where (Locations.LocationType.ID == 3) select Locations; This query will load all loca...
Entity framework and performance
Hi, I am trying to develop my first web project using the entity framework, while I love the way that you can use linq instead of writing sql, I do have some severe performance issuses. I have a lot of unhandled data in a table which I would like to do a few transformations on and then insert into another table. I run through all objects...
Entity Framework: Is there a way to check if the context has an object?
Situation: Object in session from a past context can't be set as another object's parent since other object is in a new context. Say I have a User in session that I had retrieved from a context. Now the page reloads, that context has been dismissed, and a new context is made. someUser = context.First(user => user.id == id); Session["...
Query By Entity (Example)
I’m looking for a tool that will dynamically generate Linq to Entity queries from a given entity, a Query By Entity (Example), if you will. Given an entity and the object context it belongs to, the generator returns an ObectQuery or IQueryable that could be further modified or executed. Ideally, the query builder would not directly ref...
Join in linq
Hi, is it possible to make a join in linq and only return data from one dataset where the other key was present, a little like: var q = from c in customers join o in orders on c.Key equals o.Key select new {c.Name, o.OrderNumber}; and then instead of returning just the two records then returning customers like...
Linq to Sql and Non-PK, unique-FK relationship issues
Hello everyone, I've recently been reading Louis Davidson's book on Sql Server Database Design and found it quite informative. I've picked up on alot of concepts that I didn't previously know alot (or anything) about. Primarily - I picked up on a way to set up database relationships that I hand't tried before. Basically you use a surro...
Report-Designer support for ORM (.NET)
Say I have an application that used an ORM (I am thinking of nHibernate or LINQ to Entities) for data access. How do I provide my users with the ability to do reporting against the properties of my objects? All the end user report designers I know of talk directly to a database, but I don’t like having to repeat logic in reports that ...
How can i query for null values in entity framework?
I want to execute a query like this var result = from entry in table where entry.something == null select entry; and get an IS NULL generated. Edited: After the first two answers i feel the need to clarify that I'm using Entity Framework and not Linq to SQL. The object.Equals() method doe...