c# - 在数据库中创建新记录

Question

我想使用 asp.net mvc 项目创建一个新的 ClientAccountAccess 记录。

private static void SetAccessCode(string guidCode)
        {
            using (EPOSEntities db = new EPOSEntities())
            {
                ClientAccountAccess client = new ClientAccountAccess();
                client.GUID = guidCode;
                db.SaveChanges();
            }
        }

        //have also tried 
        //ClientAccountAccess client = new ClientAccountAccess()
        //{
        //    GUID = guidCode
        //};
        //db.SaveChanges();

似乎不会保存新记录？

Answer 1

您需要将此记录添加到上下文中:

private static void SetAccessCode(string guidCode)
{
    using (EPOSEntities db = new EPOSEntities())
    {
        ClientAccountAccess client = new ClientAccountAccess();
        client.GUID = guidCode;

        // ClientAccountAccess is name of your DBSet in context. It might be different
        db.ClientAccountAccess.AddObject(client); 
        db.SaveChanges();
    }
}

这是基本 CRUD 操作的更多示例 - http://www.dotnetcurry.com/showarticle.aspx?ID=619