How to Save UniqueIdentifier into Database (Guid) by SqlCommand in C#

Опубликовано: 23 Октябрь 2024
на канале: marxapril

1,345

____________________________________________

Code:
public int Create(UserModel user)
{
using (SqlCommand cmd = Connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"
INSERT INTO [dbo].[Users]
([UserId]
,[Name]
,[Surname])
VALUES (@UserId
,@Name
,@Surname);
SELECT SCOPE_IDENTITY();";

cmd.Parameters.AddWithValue("Name", user.Name);
cmd.Parameters.AddWithValue("Surname", user.Surname);
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "UserId",
SqlDbType = SqlDbType.UniqueIdentifier,
Value = user.UserId
});

cmd.Connection.Open();

try
{
user.Id = (int)(decimal)cmd.ExecuteScalar();
}
finally
{
cmd.Connection.Close();
}

return user.Id;
}
}