数据库未创建记录
问题描述:
使用EF 5.0在数据库中插入记录不起作用。通过我的代码进行调试,我找不到任何异常。通过代码,它应该在数据库中插入一条新记录,但是当我查看数据库时,没有创建新记录。但是,我确实对数据库进行了更改,并且在调试“assestUser”(模型)时,我可以看到所有值,包括删除的列(我所做的更改)。有人能帮我解决我做错了什么吗? 这是我做了什么:数据库未创建记录
页:
public partial class _Default : Page
{
EntityContext context;
public _Default()
{
context = new EntityContext();
}
protected void btnSavePersonalDetails_Click(object sender, EventArgs e)
{
try
{
SkillsAssestUser assestUser = new SkillsAssestUser();
assestUser.DomainAcc = lblDomAcc.Text;
assestUser.Name = txtName.Text;
assestUser.Surname = txtSurname.Text;
assestUser.Division = txtDivision.Text;
assestUser.Manager = txtManager.Text;
context.SkillsAssestUsers.Add(assestUser);
context.SaveChanges();
//var assestUser = context.Set<SkillsAssestUser>();
//assestUser.Add(new SkillsAssestUser
//{
// DomainAcc = lblDomAcc.Text,
// Name = txtName.Text,
// Surname = txtSurname.Text,
// Division = txtDivision.Text,
// Manager = txtManager.Text
//});
//context.SaveChanges();
ClearPersonalDetails();
}
catch (Exception ex)
{
throw new Exception("Error inserting Details. " + ex.Message);
}
}
的DbContext:
public partial class EntityContext : DbContext
{
public EntityContext()
: base("name=SOSConnectionString")
{
base.Configuration.LazyLoadingEnabled = true;
base.Configuration.ProxyCreationEnabled = false;
}
#region AddTables
public DbSet<AdditionalSkills> AdditionalSkillss { get; set; }
public DbSet<CertifiedTraining> CertifiedTrainings { get; set; }
public DbSet<OtherCertifiedTraining> OtherCertifiedTrainings { get; set; }
public DbSet<OtherEdu> OtherEdus { get; set; }
public DbSet<SchoolEdu> SchoolEdus { get; set; }
public DbSet<SkillsAssestUser> SkillsAssestUsers { get; set; }
public DbSet<ValueAddedSkills> ValueAddedSkillss { get; set; }
#endregion
}
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
AuthConfig.RegisterOpenAuth();
Database.SetInitializer<EntityContext>(null);
}
我在做什么错? ... new to ef ....
答
首先检查连接字符串。
可以肯定,这是对的Global.asax:
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
AuthConfig.RegisterOpenAuth();
Database.SetInitializer<EntityContext>(null);
}
使用这样的代码:
using (var mycontext = new context())
{
SkillsAssestUser assestUser = new SkillsAssestUser();
assestUser.DomainAcc = lblDomAcc.Text;
assestUser.Name = txtName.Text;
assestUser.Surname = txtSurname.Text;
assestUser.Division = txtDivision.Text;
assestUser.Manager = txtManager.Text;
mycontext.SkillsAssestUsers.Add(assestUser);
mycontext.SaveChanges();
}
IMO,值得一问的,你在复制每次构建的数据库文件输出目录或者你使用SQL Server? –
@Alex,嗨,不,我没有将db文件复制到每个版本的输出目录中......我之前在Windows应用程序中使用过ef 4.1,并且这在那里工作...... – Kerieks
您是否检查过类型你分配的值是多少? – Guru