How to map table names and column name different from model in onmodelcreating method in Entity Framework -6?

c# entity-framework-6

Question

I have my database with table names starting with "tbl" prefix and column names like "ua_id" which are understandable in context of project but problematic if used in a model i.e names should be readable or meaningful(not like indicative names defined in database).

So I want to map them in my onmodelcreating method but I have no idea about it. I studied it in following blog:
http://weblogs.asp.net/scottgu/entity-framework-4-code-first-custom-database-schema-mapping but this is for EF 4.1 and method doesn't work for EF 6.(mapsingletype method)

I want to map my tables by columns to my model as I can't change the column names. I just want the newer version of that syntax in the blog.

Thank You.

1
11
4/9/2015 10:56:57 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

If you are using Code First, you can simply decorate your model with Table and Column attribute and give it the database names.

[Table("tbl_Student")]
public class Student
{
    [Column("u_id")]
    public int ID { get; set; }
}

These attributes are available in the System.ComponentModel.DataAnnotations.Schema namespace

16
4/9/2015 11:14:50 AM

Popular Answer

You can keep following inside OnModelCreating

modelBuilder.Entity<MyModel>()
.Property(e => e.MyColumn).HasColumnName("DBColumn")
wonderbell

Related Questions

Can't separate entity framework models have the same table names?

The error means, what he says: You can't use the ...default convention based mapping... in your scenario. Use ...custom database mapping... instead. Scott Guthrie has a detailed blog item about ...this....
.net c# entity-framework sql-server
asked by Dirk Brockhaus

what is the difference between entity and entity set names?

I'm using .Net 3.5 with SP1....This may be simple. But, I'm not sure about the difference between entity name and Entity Set Name...Please help me.
entity-framework
asked by gmail user

Entity Framework conflict with same table name from different databases

I ran into a situation where I had two databases (one an older version of the other) and I needed to integrate both into a single project. Naturally, almost every name conflicted....I created two separated edmx files for each database, and put each in its own namespace for clarity. I then edited each entity name to reflect which database it was com...
c# entity-framework
asked by Corey Larson

Entity Framework 6 & TPH inheritance: Map properties with the same name to same column by default

As of EF6 it is possible to do something like this when configuring Entity mappings using Table Per Hierarchy inheritance:...public class MyContext : DbContext { public DbSet<Device> Devices { get; set; } protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<ABatteryPoweredDevice>().Propert...
.net entity-framework-6 table-per-hierarchy
asked by joelmdev

Getting mapped column names of properties in entity framework

You can get to the actual string "Person_Id" from the storage model, but you cannot identify that property/column as the foreign key. For that you would need Person_Id to exist in the conceptual model. I still don't quite understand why you wouldn't want it in the model, but here's how you would get it from the storage metadata:...using ( var con...
c# entity-framework sql
asked by dudeNumber4

Get field from dynamically/programatically named column name with Entity Framework

I'm looking for a method to change column and field names dynamically/programatically;...as:...string iLoadProfileValue = "ColumnName"; string lastCol = DatabaseFunctions.DatabaseClient .tbl_MeterLoadProfile .OrderByDescending(a => a.MeterReadDate) .FirstOrDefault(a => a.MeterID == meterID).iLoadProfileValue; ...I'll change ...iLoadProfileValue...
c# entity-framework entity-framework-6
asked by Erçin Dedeoğlu

ASP Identity table column change but mapping is not possible with new column name

I have changed the asp Identity so that in database ...Id... column of ...AspNetIdentity... table be ...UserId...:...modelBuilder.Entity<ApplicationUser>() .Property(p => p.Id) .HasColumnName("UserId"); ...And that works fine. Generated table have ...UserId... instead ...Id....... Now I have another t...
asp.net-identity c# entity-framework entity-framework-6
asked by 1110

Entity Framework .net: "The Name value should be a valid navigation property name."

Hello I'm starting a project with ASP.Net and I'm following the Training Camps of Microsoft. I was trying to make a REST petition to my published api, and I got the next exception:...The ForeignKeyAttribute on property 'QuestionId' on type 'PlataformaTest.Models.AnswerModel' is not valid. The navigation property 'OptionModel' was not found on t...
asp.net c# entity-framework foreign-keys
asked by Andres Felipe

How to map Table Valued Functions in EF6 Code First with different column names?

It is possible to map a table valued functions in EF6 without edmx? The problem is that the columns in the database are named differently than in the application....My application as a simplified example....Database...The table ...user... on SQL Server 2016:...User Id (int, Identity, PK) Name (nvarchar(255) ...The table valued function ...GetUser...
c# entity-framework entity-framework-6 sql-server user-defined-functions
asked by cSteusloff

Use a variable table name for Entity Framework SqlQuery to fetch data into entity Class

I want to convert string var to entity framework class but I don't now how. I have searched a lot but can not found anything...public JsonResult GetReports(string tbl) { using (Context db = new Context()) { // *** Problem is that tbl is string and I want to Cast tbl // to Users Class OR eny of my other Class v...
c# entity-framework-6 generics linq
asked by Pooria.Shariatzadeh

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow