8,735
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE [dbo].[NEXT_VAL]
AS
BEGIN
BEGIN TRANSACTION
declare @NEXT_VAL INTEGER
SELECT @NEXT_VAL = VAL FROM SEQ_SEED UPDLOCK
UPDATE SEQ_SEED SET VAL= VAL + 1
SELECT @NEXT_VAL = VAL FROM SEQ_SEED
SELECT VAL as NEXT_VAL FROM SEQ_SEED
COMMIT
return @NEXT_VAL
END
#region Function Imports
/// <summary>
/// No Metadata Documentation available.
/// </summary>
public ObjectResult<Nullable<global::System.Int32>> NEXT_VAL()
{
return base.ExecuteFunction<Nullable<global::System.Int32>>("NEXT_VAL");
}
#endregion
/// <summary>
/// 用于获取主键标识的函数(执行存储过程)
/// </summary>
/// <returns>主键</returns>
[Invoke]
public int GetNewId()
{
return Convert.ToInt32(this.ObjectContext.NEXT_VAL().FirstOrDefault());
}
//客户端的调用
CallModelDomainContext myDomainContext = new CallModelDomainContext();
MessageBox.Show(myDomainContext.GetNewId().Value.ToString());