Here is the situation. There are two type of ElectricConsumer ie CommercialConsumers & DomesticConsumers(Quaters) and one Quater is allocated to one Employee. Below is my code but encount...

I'm using entity framework in an asp.net mvc 3.0 application. I'm using a table-valued function to do a full text search on one of my database tables. I have set the return type to an object of typ...

We are currently investigating the use of OData query syntax in our Web APIs. We are not looking to implement a full OData implementation - merely leverage the query syntax. It is generally consid...

We have a table that looks roughly like this: CREATE TABLE Lockers { UserID int NOT NULL PRIMARY KEY (foreign key), LockerStyleID int (foreign key), NameplateID int (foreign key) } All of th...

I am trying to use ADO.Net Codefirst feature of latest Entity Framework 4.0. As part of that I have installed Entity Framework CTP 4 from Microsft and using Scott's tutorial to create the model fir...

I have the following Model: public class ContractPlain { public int Id { get; set; } public Guid ContractGuid { get; set; } public int SenderId { get; set; } public int RecvId { get; set; } p...

I wrote a few assumptions regarding Entity Framework, then a few questions (so please correct where I am wrong). I am trying to use POCOs with EF 4. My assumptions: Only one data context can exi...

I'm new to the Entity model thing and i'm looking for an advise how to organize my Entity model. should i create one entity model file (.edmx) which will contain all the tables in my database or s...

I wish to build a partial view that gets a model column and print it. Something like that: At the view: @model IEnumerable<products_comparison.Models.Product> @{ ViewBag.Title = "Index"; v...

Is it possible to define primary and foreign keys for database Views in Microsoft SQL Server Management Studio? How? I'm trying to create an ADO.NET Entity Data Model to read from four old, poorly...

I'm having problems quering this (I am new to LINQ, please forgive me) and I have spent hours trawling the web. In SQL I just want to do this SELECT c.Forname, c.Surname cg.Title, g.GroupName F...

I'm working on my first .NET project (.NET 3.5, ADO.NET and C#). We've built our entity models and are trying to build a clean business objects layer. We've got our basic entity model and we want ...

I have my domain split into multiple Entity Framework models. I have some shared entities that span multiple models (named Lookup), however, these are replaced with "using" references using the met...

I have a DateTime property. I need this property's default value to be DateTime.Now. And then I found out that you can specify an attribute StoreGeneratedPattern="Computed" and set it to (getdate()...

I've just finished going through the MvcMusicStore tutorial found here. It's an excellent tutorial with working source code. One of my favorite MVC v2 tutorials so far. That tutorial is my first i...

I have two SQL Server tables with Primary Keys (PK) and a Foreign Key (FK) linking the two tables: 1) Table "Order" OrderID, int, PK AddressID, int, FK ... 2) Table "Address" AddressID, int, P...

How do you change the name of the connection string that Entity Framework models are bound to by default? Let's say I create an Entity Framework data model named "Model1.edmx" by pointing it to a ...

I was wondering if it was wise to cache the Entity Framework's ObjectContext object in the Cache; will this give me issues with multiple connections at the same time that the user will experience i...

I know how to mark a group of fields as primary key in ADO.NET entities but i haven't found a way to declare unique constraints or check constraints. Is this feature missing on the designer or on ...