Entity Framework 6 - Knowledge Base (KB)

'Contains()' workaround using Linq to Entities?

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 ...

How to mock ObjectContext or ObjectQuery<T> in Entity Framework?

How to mock ObjectContext or ObjectQuery in Entity Framework?

Which is the best book out there to learn Linq, including 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.

Function Imports in Entity Model with a non-Entity Return Type

I have a stored procedure in my Entity Data Model and added it to the function imports....Problem is... Visual Studio generates the function code in the model's code-behind if and only if I specify the return to be an entity type. ...Scalar and null retu...

Updating your edmx to reflect changes made in your db (.net linq-to-entities)

So I have my edmx made. ...Then I change my database a little bit, changing a column to from being a NOT NULL to allowing NULL....I go into my edmx, right click and choose "Update Model from Database"...Now I go into my program and it hasnt actually upda...

How can I attach an Entity Framework object that isn't from the database?

I have a complete separation of my Entity Framework objects and my POCO objects, I just translate them back and forth......i.e:...// poco public class Author { public Guid Id { get; set; } public string UserName { get; set; } } ...and then I have an...

Entity Framework and SQL Server View

For several reasons that I don't have the liberty to talk about, we are defining a view on our Sql Server 2005 database like so:...CREATE VIEW [dbo].[MeterProvingStatisticsPoint] AS SELECT CAST(0 AS BIGINT) AS 'RowNumber', CAST(0 AS BIGINT) AS 'Pr...

When does Entity Framework open and close Database Connections?

When I instance my "Entities" object in Entity Framework, and make a couple of queries using that Entities object, what happens to connections?...Does it open a connection when I instance the object, and close it when I dispose of it?...Or does it open an...

Entity Framework 3.5 - How to load children

My questions is probably very simple, how do you load children/subclasses. There is no "load" or anything like it that I can find to have the context load the children. ...the context class is of ObjectContext type, see below:...public partial class RTIPr...

bulk insert and update with ADO.NET Entity Framework

I am writing a small application that does a lot of feed processing. I want to use LINQ EF for this as speed is not an issue, it is a single user app and, in the end, will only be used once a month....My questions revolves around the best way to do bulk ...

How do I eliminate Error 3002?

Say I have the following table definitions in SQL Server 2008:...CREATE TABLE Person (PersonId INT IDENTITY NOT NULL PRIMARY KEY, Name VARCHAR(50) NOT NULL, ManyMoreIrrelevantColumns VARCHAR(MAX) NOT NULL) CREATE TABLE Model (ModelId INT IDENTITY NOT N...

Entity Framework select single value from row

I am using Entity Framework from .NET 3.5...I have two tables with 0-1 to many relation. Let's say Citizen and City. Each citizen has foreign key column (ID) that connects him to City....When i select single citizen, i also need to select the name of the ...

LINQ subquery "NOT IN" problem

I do not understand why this query fails....var qTags = from tagsU in _context.ADN_ProductTagsView where !(from o in _context.ADN_ProductTagsView where o.ProductID == productId select o.ProductTagID).Contains(tagsU.ProductTagID) select ta...

Download Entity framework for .NET 3.5

Which version of the ...Entity Framework... (EF) I could use in ....NET 3.5... and where I could download this older version?