Entity Framework 6 - Knowledge Base (KB)
6940 results
TreeView Binding in WPF
I've got a class with Parent and Children properties....ADO.NET Entity Framework Hierarchical Page Class http://img148.imageshack.us/img148/6802/edmxxe8.gif...I want to display this hierarchy in a WPF treeview....Here's my XAML......<TreeView Margin="12" ...
asked by Zack Peterson
Entity Framework tracks every data update.
There is a need from a customer to log every data change to a logging table with the actual user who made the modification. The application is using one SQL user to access the database, but we need to log the "real" user id....We can do this in t-sql by w...
asked by Biri
Within a generic extension method, how do I apply OrderBy to an IQueryable using a string column name?
public static IQueryable<TResult> ApplySortFilter<T, TResult>(this IQueryable<T> query, string columnName) where T : EntityObject { var param = Expression.Parameter(typeof(T), "o"); var body = Expression.PropertyOrField(param,columnName); var sor...
asked by JTew
With Linq to Entity, how do I obtain the maximum ID?
I have a table User which has an identity column ...UserID..., now what is the correct Linq to Entity line of code that would return me the max ...UserID...?...I've tried:...using (MyDBEntities db = new MyDBEntities()) { var User = db.Users.Last(); ...
asked by Ray
Date time and SQL Server 2008 and SQL Server 2005
I've built a entity framework model against a 2008 database. All works ok against the 2008 database. When I try to update the entity on a 2005 database I get this error. ...The version of SQL Server in use does not support datatype 'datetime2...I speci...
asked by Monroecheeseman
ADO.NET Entity Framework and TDD
I've been playing with ADO.NET Entity Framework lately, and I find that it suits my needs for a project I'm developing. I also find cool its non-invasive nature....After generating a data model from an existing database you are faced with the task of inte...
asked by Dario Solera
Group Optimization In LINQ to Entities, by
I have this query in LINQ to Entities.... var query = (from s in db.ForumStatsSet where s.LogDate >= date1 && s.LogDate <= date2 group s by new { s.Topic.topicID, s.Topic.subject, s.Topic.Forum.forumName, s...
asked by Olaj
Entity Framework unit testing
I want to test my Entities that are built using Entity Framework. My concern is that using Entity Framework means directly working with data source. So any ideas how to unit testing Entity Framework based components?
asked by Muhammad Soliman
If Contains isn't supported, how can you make a SQL-style 'IN' query in LINQ to Entities (Entity Framework)?
I'm using LINQ to Entities (not LINQ to SQL) and I'm having trouble creating an 'IN' style query. Here is my query at the moment:...var items = db.InventoryItem .Include("Kind") .Include("PropertyValues") ....
asked by JC Grubbs
Entity Framework Reference
I'm trying to setup the Entity Framework with SQL Server 2008. I'm using Guids for the keys on my tables. Is there a way to set it up so the keys are automatically generated by the database? I tried setting "RowGuid" to true and also set the column's d...
asked by Jake Pearson
Why isn't ODBC supported by Entity Framework?
Is there a specific reason that the EF requires new data providers and can't make use of ODBC? I figured it had to be some ORM specific problem, but NHibernate works fine via ODBC....I'm using NHibernate and can continue to use Nhibernate, but I worry th...
asked by anonymous
Using Linq to Entities as a workaround for 'Contains()'?
I'm trying to create a query which uses a list of ids in the where clause, using the Silverlight ADO.Net Data Services client api (and therefore Linq To Entities). Does anyone know of a workaround to Contains not being supported?...I want to do something ...
asked by James Bloomer
Cross edmx "join" between Linq to Entities and Entity Framework
I have two entities, each from a different database and therefore different edmx files. There is, however, an infered relationship between them....Foo... has many ...Bar...s for example....What's the easiest way to do this join in the EntityFramework, wit...
asked by NikolaiDante
In LinQ-to-Entities, adding to the Where clause of an Update
Let's say I have a table called Product, with three columns: Id, CustomerId, Name. Id is the primary key. The schema is outside of the control of my group, and we now have a requirement to always provide CustomerId as a parameter for all queries (selects...
asked by Joel Martinez
Working with detached and connected objects in Entity Framework
Firstly, let me set out what I'd like to do. Assume I have three types of ...EntityObject..., ...MetaData..., ...Data1... and ...Data2.... ...MetaData... is, as one would expect, has a reference to one instance each of ...Data1... and ...Data2.... Now, fo...
asked by biozinc
ASP.NET DropDownList Databinding with Entity Framework
I'm trying to bind an ASP.net DropDownList to the results of an entity framework query, while still maintaining multi-tier separation. (i.e. I don't want my UI code to contain query details, nor my Data Layer code to have UI dependencies.) My code-behin...
asked by AndrewCr
Adding existing entities to a collection on a newly built object using the entity framework
I am using the Entity framework to create a new order. The order contains a collection of contacts, a many to many relationship. I want to add a reference to an existing contact on the order on creation of the order. Both Order and Contact a Entity Obj...
asked by kirkmcpherson
In Entity Framework, how do you spoof ObjectContext or ObjectQueryT>?
How to mock ObjectContext or ObjectQuery in Entity Framework?
asked by saeed
Entity Framework Join and Include
I have the following query of linq to entities. The problem is that it doesn't seem to load the "Tags" relation even though i have included a thing for it. It works fine if i do not join on tags but i need to do that.... var items = from i in d...
asked by Olaj
Which book is the best for learning Linq, especially Linq to Entities?
I heard lots of reviews on the book Linq in Action, but it does not cover Linq to Entities. ... Please provide your feedback on the books you may have read.
asked by Binoj Antony
Page 2 of 347
