How to give a Table name in Entity Framework by code first approach in .Net Framework 4.0?

Question

In .NET 4.0 framework the System.ComponentModel.DataAnnotations.Schema doesn't work or doesn't support I think.

I am using a code-first approach and my database already exists, and also not using ADO.net Entity Data Model.

I already used the [Table] attribute and DatabaseGenerated attribute, it's not working causing a compilation error to occur.

This is my code:

Entity class:

public class myclass
{
    public myclass()
    {
        //
        // TODO: Add constructor logic here
        //
    }

    [Key]
    public int RECORDID { get; set; }
    public string AA { get; set; }
    public string CAT { get; set; }
    public string CS { get; set; }
    public int? FS { get; set; }
    public int? CA { get; set; }
    public int? DR { get; set; }
    public int? UM { get; set; }
    public int? ID { get; set; }
    public double LAT { get; set; }
    public double LON { get; set; }
    public int? NIC { get; set; }
}

DbContext class:

public class classContext : DbContext
{
    public classContext() : base("name=DBConnection")
    {
        //Disable initializer
        Database.SetInitializer<classContext>(null);
    }

    public DbSet<myclass> myclasses { get; set; }
}

Or I have to add this override method of model creating, is it helpful or not?

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
        modelBuilder.Entity<myclass>().ToTable("Datatbl");
}

Help me out. Thanks

You can have a look at weblogs.asp.net/scottgu/…

Justin CI
– Justin CI

2016-05-20 12:07:37 +00:00
Commented May 20, 2016 at 12:07 — Justin CI
– Justin CI, Commented May 20, 2016 at 12:07

error_handler · Accepted Answer · 2016-05-20 10:05:14Z

1

You can Use Table attribute over your class:

[Table("Datatbl")]
public class myclass
{
}

answered May 20, 2016 at 10:05

error_handler

1,21112 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

SanjeevD Over a year ago

#manoj : the table Attribute use System.ComponentModel.DataAnnotations.Schema namespace or i am using the 4.0

error_handler Over a year ago

Yes it uses the System.ComponentModel.DataAnnotations.Schema

SanjeevD Over a year ago

but its not there in the Reference library.

Collectives™ on Stack Overflow

How to give a Table name in Entity Framework by code first approach in .Net Framework 4.0?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related