fakhravari
سه شنبه 05 دی 1391, 23:25 عصر
/// <summary>
/// پیداکردن کلید از نوع Identity
/// </summary>
/// <param name="TableName">ورودی نام جدول</param>
private static bool FindIsIdentity(string TableName, bool States = true)
{
string Text = DAL.ExecuteScalar("select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA = 'dbo' and COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1 and TABLE_NAME =N'" + TableName + "'");
if (Text == null)
return false;
else
return true;
}
/// <summary>
/// پیداکردن کلید از نوع PrimaryKey
/// </summary>
/// <param name="TableName">ورودی نام جدول</param>
private static string FindIsPrimaryKey(string TableName)
{
return DAL.ExecuteScalar("SELECT column_name FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE OBJECTPROPERTY(OBJECT_ID(constraint_name), 'IsPrimaryKey') = 1 AND table_name = N'" + TableName + "'");
}