Entity Framework 6 - Knowledge Base (KB)

Display empty textbox using Html.TextBoxFor on a not-null property in an EF entity

I am using Entity Framework (v4) entities. I have an entity called Car with a Year property of type integer. The Year property does not allow NULL. I have the following in my Create view:...<%= Html.TextBoxFor(model => model.Year) %> ...I am required to r...

Using DataAnnotations with Entity Framework

I have used the Entity Framework with VS2010 to create a simple person class with properties, firstName, lastName, and email. If I want to attach DataAnnotations like as is done in this ...blog post... I have a small problem because my person class is dy...

Mapping and metadata information could not be found for EntityType Exception

I am trying out ASP.NET MVC Framework 2 with the Microsoft Entity Framework and when I try and save new records I get this error: ...Mapping and metadata information could not be found for EntityType 'WebUI.Controllers.PersonViewModel'...My Entity Framewo...

Entity Framework CTP4: where to put SetInitializer?

I am attempting to add Entity Framework, code first, to an MVC application that's been running with test data, using the CTP4 preview....I am currently getting this error:...The model backing the 'SchedulerContext' context has changed since the database w...

How to use a ShortDate string format with Html.TextBoxFor

Using Entity Framework with MVC2, I have a series of date textboxes, that I want to display data from the model in a short date format, but I have to use Html.TextBoxFor in order for the update code to work (Having tried using HTML.Textbox the data never...

ASP.NET MVC 2 - "The model of type 'XYZ' could not be updated" when using UpdateModel and LINQ to Entities (.NET 3.5)

I have a model set up using LINQ to Entities and have code working that adds to the database as expected. However, I can't get UpdateModel to work when I am using .NET 3.5....[HttpPost] public ActionResult Edit(Site.Models.XYZ xyz) { try { ...

Where to put Entity Framework Data Model in MVC application?

Lets consider default ASP.NET MVC application folder structure, so it's looks like this:...-App_data -Content -Controllers HomeController.cs -Models AccountModels.cs -Scripts -Views ...My question is: Where is the best place to put Entity Framewor...

ASP.NET MVC 2.0 Implementation of searching in jqgrid

Hi I am trying to use the single column search in jqgrid using MVC 2 IN .NET (VS 2008) this is the code I have so far but I need an example to match it with or a tip of what I am missing ...jQuery("#list").jqGrid({ url: '/Home/DynamicGridData/', ...

How many Include I can use on ObjectSet in EntityFramework to retain performance?

I am using the following LINQ query for my profile page:...var userData = from u in db.Users .Include("UserSkills.Skill") .Include("UserIdeas.IdeaThings") .Include("UserInterests.Inte...

Fetch top N rows of the table in Entity Framework

I'm kind of stuck with a problem that I'm having. Among others, I have this tables in my DB:...Product (int productId, ...otherProductInfo) Customer (int customerId, ...otherCustomerInfo) SoldToData ( int productId, int customerId) ...I want to get top te...

Populating textbox with data based on dropdown list selection (onChange)

I am building a website using ASP.NET MVC and entity framework. I have a DB table with Country info:...CountryID int; ShortName nvarchar; CountryCode nvarchar; ...In my View I have:...<div class="editor-field"><%: Html.DropDownListFor(model => model.addre...

Insert new record into database using Entity Framework

I have a table in my database like this:...[id] [uniqueidentifier] NOT NULL, [user_id] [uniqueidentifier] NOT NULL, [download_type] [nvarchar](50) NOT NULL, [download_id] [nvarchar](50) NOT NULL, [download_date] [datetime] NOT NULL, [user_ip_address] [nva...

N-Tier Architecture with Service Layer, Business Layer, and Entity Framework

Just wanted some feedback/help with the way I'm architecturing my application. My current solution structure looks something like this:...UI (Actual MVC application)...Core (only Controllers & ViewModels)...Services...BLL ...Data (Entity framework DbConte...