private static IdentityCreatorEntity GetCurrentSeed(string key, string dimension, Database db, DbTransaction trans)
{
var sql = string.Format("SELECT * FROM identity_creator WITH (HOLDLOCK, UPDLOCK) WHERE identity_key=@p_key and dimension=@p_dimension", COLUMNS);
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_key", DbType.String, key);
db.AddInParameter(dc, "p_dimension", DbType.String, dimension);
using (var reader = db.ExecuteReader(dc, trans))
{
if (reader.Read())
{
var entity = new IdentityCreatorEntity();
entity.Init(reader);
return(entity);
}
}
return(Create(key, dimension, db, trans));
}
