public string GetTableId(string connectionString, string databaseName, string tableName)
{
if (WebConfigUtils.IsMySql)
{
return(tableName);
}
if (string.IsNullOrEmpty(connectionString))
{
connectionString = ConnectionString;
}
var tableId = SqlUtils.Cache_GetTableIDCache(databaseName, tableName);
if (string.IsNullOrEmpty(tableId))
{
string sqlString =
$"select id from [{databaseName}].dbo.sysobjects where type in ('U','V') and category<>2 and name='{tableName}'";
using (var rdr = ExecuteReader(connectionString, sqlString))
{
if (rdr.Read())
{
tableId = GetString(rdr, 0);
SqlUtils.Cache_CacheTableID(databaseName, tableName, tableId);
}
rdr.Close();
}
}
return(tableId);
}