本文整理匯總了C#中OGen.Libraries.DataLayer.DBConnection.Execute_SQLQuery方法的典型用法代碼示例。如果您正苦於以下問題：C# DBConnection.Execute_SQLQuery方法的具體用法？C# DBConnection.Execute_SQLQuery怎麽用？C# DBConnection.Execute_SQLQuery使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類OGen.Libraries.DataLayer.DBConnection的用法示例。
在下文中一共展示了DBConnection.Execute_SQLQuery方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: Execute_SQL__delete
private void Execute_SQL__delete(DBConnection dbconnections_in) {
switch ((DBServerTypes)Enum.Parse(typeof(DBServerTypes), dbconnections_in.DBServerType)) {
case DBServerTypes.SQLServer:
case DBServerTypes.PostgreSQL: {
dbconnections_in.Execute_SQLQuery(string.Format(
"delete from \"CRD_User\" where \"Login\" = 'test-{0}'",
this.testid_
));
break;
}
default: {
throw new Exception(
string.Format(
"unsuported db type: {0}",
dbconnections_in.DBServerType.ToString()
)
);
}
}
}示例2: Execute_SQL__insert
private void Execute_SQL__insert(DBConnection dbconnections_in) {
switch ((DBServerTypes)Enum.Parse(typeof(DBServerTypes), dbconnections_in.DBServerType)) {
case DBServerTypes.SQLServer:
case DBServerTypes.PostgreSQL: {
dbconnections_in.Execute_SQLQuery(string.Format(
"insert into \"CRD_User\" (\"Login\", \"Password\", \"IFApplication\") values ('test-{0}', 'password', null)",
this.testid_
));
break;
}
default: {
throw new Exception(
string.Format(
"unsuported db type: {0}",
dbconnections_in.DBServerType.ToString()
)
);
}
}
}