Entity Framework Model Multiple Table to Single Entity?

I've two tables named Modules and Privileges which are related by a foreign key relationship as shown below: I'd ...

Entity Relationship Diagram for Hotel?

I need to create an ERD for a hotel, the question reads as follows: "The owner of a set of hotels would like to hav...

Why use Attach for update Entity Framework 6??

While searching for the best practivies of performing CRUD operation via EF I noticed that it is highly recommended ...

Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths - why??

I've been wrestling with this for a while and can't quite figure out what's happening. I have a Card entity which c...

Exception handling in Entity Framework?

I have a form that it has some field and has relationship with database. I'm using entity framework I wanna handle e...

Purpose of EF 6.x DbContext Generator option when adding a new data item in Visual Studio?

I have a web app that I built using LINQ to SQL and I'm looking to upgrade it to LINQ to Entity Framework. I've look...

Best way to check if object exists in Entity Framework??

What is the best way to check if an object exists in the database from a performance point of view? I'm using Entity...

The object 'DF__*' is dependent on column '*' - Changing int to double?

Basically I got a table in my EF database with the following properties: public int Id { get; set; } public string ...

Entity framework left join?

How do I change this query so it returns all u.usergroups? from u in usergroups from p in u.UsergroupPrices select ...

How should I edit an Entity Framework connection string??

I recently had to edit my app.config file to change the connection string for an Entity Framework data model (.edmx ...

MSSQL Error 'The underlying provider failed on Open'?

I was using an .mdf for connecting to a database and entityClient. Now I want to change the connection string so tha...

Subquery with Entity Framework?

I'm porting a subsystem from NHibernate to Entity Framework and want to see the best way to port the following query...

A circular reference was detected while serializing an object of type 'SubSonic.Schema .DatabaseColumn'.?

I am trying to do a simple JSON return but I am having issues I have the following below. public JsonResult GetEven...

Entity Framework Timeouts?

I am getting timeouts using the Entity Framework (EF) when using a function import that takes over 30 seconds to com...