Entity Framework 6 - Knowledge Base (KB)

When constructing an ADO.NET Model, how do you set your sensitive data in the application code?

I am creating a model for a database and was curious at the following statement in the ADO.NET Entity Model wizard where you have the options of choosing Yes or No as where to store sensitive data - ..."No, exclude sensitive data from the connection strin...

First List of Entity Framework Code Mapping of Properties

I am working with Entity Framework Code first. I have a simple model:...public class Variable { public string Name { get; set; } public int Id { get; set; } public IList<string> TextOptions { get; set; } } ...I ran in...

What is the difference between a Model and an Entity?

I am confused to understand what is the meaning of this words:...Entity..., ...Model..., ...DataModel..., ...ViewModel...Can any body help me to understanding them please? Thank you all.

The supplied data reader is incompatible with... There is no equivalent column in the data reader for a member of the type 'Finalised.'

I have added a column in my Sql Server Db then in VS i updated model from database, there a template auto generated some code....The code compiled fine, but when i try access a the data base, the following error occurs:...The data reader is incompatible w...

Incompatible Data Reader Exception From EF Mapped Objects

I am using Entity Framework and have updated a table and its stored procedure but I'm getting the following error when the stored procedure is called....The data reader is incompatible with the specified 'FormValueModel.Valuation'. A member of the type,...

The binary operator Equal is not defined between type Nullable<Int32> and Int32

I have the following model:...public class DeviceConfigurationModel { [Key] [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)] [Display(Name = "Device Configuration Id")] public int DeviceConfigurationId { get; set; } [Req...

Entity Framework (Code First) - Dynamically Building a Model

I have an assembly with classes my domains - "Domains.dll". I dynamically add to my DbContext Dbset load classes of assembly....public class MyContext : DbContext { public MyContext() : base("DBConnection"){} protected override void OnModelCreating...

ASP.NET MVC without Models and Entity Framework

I am going to migrate an ASP.Net application to ASP.NET MVC, and I am thinking to avoid Models and Entity Framework. Instead I will use methods to direct access databases....My question here is that is it possible? What is the performance difference betwe...

Should I use an int or a long for the primary key in an entity framework model

I am writing an MVC5 Internet application and I have a question about the id field for a model....Should I use an int or a long for the id in a model? I am talking about the field that is used for the primary key? Is an int enough if the database has 100,...

MVC 5 not validating StringLength attribute properly

I'm trying to validate the sortCode field in my PersonPaymentDetails model but my view is failing to validate the StringLength(6). If I submit the form with a value of length 1 it incorrectly validates successfully....Am I doing something fundamentally wr...

Define foreign key for ICollection in Entity Framework model

How to define in ...Entity Framework 6..., which columns will be used to reference data in an ...ICollection<>...?...For example, we have a simple User-Information relation, were i can get all information from a user which updated or created the informati...

What is the best practice of passing data from a controller to a view layout?

I currently have a MVC site that needs to have dynamic content on the header of every page....I currently get the required data as normal in the controller and place it in a View Model. In the view, I take the data and stick the template parts in to the V...

Entity Framework nesting classes inside class

I trying to make a data model that allows users to add companies to a list and then when added, allow further details on the company to be added, this is to allow things like employee information to be added. However, I haven't been able to figure out how...

Entity Framework Core null object one-to-one

Entity Framework Core null object. I have a one-to-one entity relationship....public class Player { public int Id { get; set; } public int? RatingId { get; set; } public Rating Rating { get; set; } } public class Rating { public double ...