Click here to Skip to main content
15,891,136 members
Articles / MVC
Tip/Trick

How to change database with Entity Code First in ASP.NET MVC3

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
8 Jan 2013CPOL 11.2K   2   2
A website application with ASP.NET MVC3 for my blog http://truongminhtuan.info.

While implementing a project with Entity Code First, I found out an interesting thing to share. In the project I made a personal blog. Here I create a class that contains the attributes, in this case a Table

I create a class Article with properties, including:

C#
public class Article
{
    //[Key]
    public int ArticleId { get; set; }
    public string Title { get; set; }
    public string Description { get; set; }
    [Required]
    [Column(TypeName = "ntext")]
    [MaxLength]
    public string Content { get; set; }

    private DateTime _datetime = DateTime.Now;
    public DateTime DateTime {
        get { return _datetime; } set { _datetime=value;} 
    }
    public int Hot { get; set; }
    public string AccountId { get; set; }
    public int CategoryId { get; set; }
    public int Active { get; set; }
}

Next, I create a DbContext for generating class Article into Table Article:

C#
public DbSet<Article> Article { get; set; }

Then, I change in Global for section Application_Start:

C#
protected void Application_Start()
{
    AreaRegistration.RegisterAllAreas();
    RegisterGlobalFilters(GlobalFilters.Filters);

    RegisterRoutes(RouteTable.Routes);
    Database.SetInitializer<BlogContext>(null);            
}

Then press F5 for run project.

Happy coding!

This article was originally posted at http://truongminhtuan.info

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Web Developer iFsoft Software Center
Vietnam Vietnam
I am a Developer for ASP/ASP.NET and currently a CEO of a small E-learning company in VietNam. We are very much active in making training videos , writing books and center trainings. Do visit my site for http://truongminhtuan.info

Comments and Discussions

 
QuestionDatabase can not change if Model is changed Pin
Sang Huynh (S3)15-Jan-13 17:18
Sang Huynh (S3)15-Jan-13 17:18 
AnswerRe: Database can not change if Model is changed Pin
TRUONG MINH TUAN17-Jan-13 20:02
TRUONG MINH TUAN17-Jan-13 20:02 
OK. But When you change Table then Models unknown. So, you have delete EMD or Metadata in file .sdf

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.