ASP.NET MVC: EF 沒有建立資料庫表

標籤：

設定連接字串時,Name屬性的值,應該等於建立的EF資料庫類類名

 

比如:

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Data.Entity;using MVC_example.Models;namespace MVC_example.DataAccessLayer{    public class Cnn : DbContext    {        private DbSet<User> _users;        public DbSet<User> Users        {            get            {                return _users;            }            set            {                _users = value;            }        }        protected override void OnModelCreating(DbModelBuilder modelBuilder)        {            modelBuilder.Entity<User>().ToTable("tUser");            base.OnModelCreating(modelBuilder);        }    }}

 其中定義了類名為Cnn,則Web.config中的ConnectionString

應為:

<connectionStrings>    <add connectionString="Data Source=.;Initial Catalog=SalesERPDB;Integrated Security=True;" name="Cnn" providerName="System.Data.SqlClient" />  </connectionStrings>

 

ASP.NET MVC: EF 沒有建立資料庫表