使用ADO.NET实体获取身份行值 [英] getting identity row value using ADO.NET Entity

问题描述

我在SQL Server 2008数据库中有以下表：

I have the following table in SQL Server 2008 database:

User
--------------------------------------------------------
Id           Numeric(18, 0) | Identity(1, 1) PK not null
Name         Nchar(20)      | Not null

我正在使用ADO.NET实体数据模型：

I'm using an ADO.NET Entity Data model to do:

MyEntities entities;
try
{
    entities = new MyEntities();
    if (entities.User.Count(u => u.Name == userName) == 0)
    {
        entities.User.AddObject(new User()
        {
            Name = userName
        });
        resultCode = 1;
        entities.SaveChanges();
    }
    else
    {
        resultCode = 2;
    }
}
catch
{
    resultCode = 3;
}
finally
{
    if (entities != null)
        entities.Dispose();
}

如何添加新用户的User.Id？

How can I get User.Id for new User added?

推荐答案

尝试保留对用户对象的引用。一旦SaveChanges（）被调用，Id应该被自动更新。以下是您的代码的修改：

Try keeping a reference to the user object. Once SaveChanges() is called, the Id should automatically be updated. Here's a modification of your code to demonstrate:

if (entities.User.Count(u => u.Name == userName) == 0)
{
    User newUser = new User()
    {
        Name = userName
    };
    entities.User.AddObject(newUser);
    resultCode = 1;
    entities.SaveChanges();

    // newUser.Id should be populated at this point.
}

这篇关于使用ADO.NET实体获取身份行值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！