Entity Framework 6 - Knowledge Base (KB)

EF code first migrations from Pascal Case Properties to lower case columns

In Entity Framework 6 Code First, is there a way (perhaps via Data Annotations or Fluent API) so that the database generated by Migrations has lower case column names, even though my model classes have Pascal Casing properties?...I.e. This class:... publi...

DBContext Method not found (System.MissingMethodException on OnModelCreating())

I've been stuck with below exception from OnModelCreating() in DBContext and struggling to find the cause or a solution. Can't find much help online either.... {System.MissingMethodException: Method not found: 'System.Nullable`1<Int32> Models.Application...

How to insert a record into a table with a foreign key using Entity Framework in ASP.NET MVC

I'm new to Entity Framework code-first. This is my learning in ASP.NET MVC, using code-first for database creation....I have two classes:...public class Student { public int StudentId { get; set; } public string Name { get; set; } public int S...

Entity Framework 6: How to map array elements to table columns

[I'm surprised that I didn't find an existing question with an answer to this conceptual question. Maybe I just didn't search the right keywords.]...Consider an entity type "Singer" with some of its own properties. Next, consider an entity type "Quartet"...

Entity Framework: how to set the type of a column as uniqueidentifier with Fluent API

I use Entity Framework 6, code-first....I have a column ...<string> Id... that is created by a framework (Azure Mobile Server SDK), which I don't have access to....public abstract class EntityData { [Key] [TableColumn(TableColumnType.Id)] publ...

Custom key with autoincrement

I have an entity with...entity.Property(f => f.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.None); ...because for some reason, I need to enter some id's manually. is it possible to automatically add the next available id (int) if the id is not p...

It is possible to query a NotMapped property?

i'm working with EF6 code first, and i used ...this... answer to map a ...List<stirng>... in my entitie....This is my class... [Key] public string SubRubro { get; set; } [Column] private string SubrubrosAbarcados { get ...

How to define a navigation property via Entity Framework code first approach

I have the following class that I want to use as my data context in Entity Framework:... public class AggregateRecord : IAggregateRecord { [Key] public int AggregateRecordID { get; set; } public DateTime? InsertDate { get; s...