public string GetUpdateSql <T>(string updateFields)
{
var table = OracleCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
if (string.IsNullOrEmpty(updateFields))
{
return(table.UpdateSql);
}
return(CommonUtil.CreateUpdateSql(table, updateFields, "\"", "\"", ":"));
}
public string GetByIdsSql <T>(string returnFields)
{
var table = SqlServerCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
if (string.IsNullOrEmpty(returnFields))
{
return(table.GetByIdsSql);
}
else
{
return(string.Format("SELECT {0} FROM [{1}] WITH(NOLOCK) WHERE [{2}] IN @ids", returnFields, table.TableName, table.KeyName));
}
}
public string GetByIdsSql <T>(string returnFields)
{
var table = PostgreCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
if (string.IsNullOrEmpty(returnFields))
{
return(table.GetByIdsSql);
}
else
{
return(string.Format("SELECT {0} FROM \"{1}\" WHERE \"{2}\"=ANY(@ids)", returnFields, table.TableName, table.KeyName));
}
}
public string GetByIdsSql <T>(string returnFields)
{
var table = MySqlCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
if (string.IsNullOrEmpty(returnFields))
{
return(table.GetByIdsSql);
}
else
{
return(string.Format("SELECT {0} FROM `{1}` WHERE `{2}` IN @ids", returnFields, table.TableName, table.KeyName));
}
}
