public static DataSourceSchema BuildTableSchema(string connName, string tableName)
{
string defCon = ConnectionAdmin.getDefaultConnName();
if (!string.IsNullOrEmpty(connName) && connName.Equals(defCon, StringComparison.OrdinalIgnoreCase))
{
connName = null;
}
DatabaseAdmin dba = DatabaseAdmin.getInstance(connName);
DataSourceSchema ret = new DataSourceSchema();
ret.ConnectionName = connName;
ret.TableName = tableName;
ret.SelectCommand = new CommandSchema();
ret.SelectCommand.CommandText = tableName;
ret.SelectCommand.CommandType = CommandType.TableDirect;
BuildFields(ret);
ret.PrimaryKeys = dba.GetPrimaryKeys(tableName);
BuildSchemaCommand(ret);
//string dsId = tableName;
//if (!string.IsNullOrEmpty(connName))
// dsId = connName + "." + dsId;
// DataSourceSchemaContainer.Instance().AddItem(dsId, ret);
return(ret);
}
public static Database GetDb()
{
string connName = _settings.ConnectionName;
if (string.IsNullOrEmpty(connName))
{
connName = ConnectionAdmin.getDefaultConnName();
}
Database db = DatabaseFactory.CreateDatabase(connName);
return(db);
}
public static DataSourceSchema BuildTableSchema(string connName, string tableName)
{
string defCon = ConnectionAdmin.getDefaultConnName();
if (connName.Equals(defCon, StringComparison.OrdinalIgnoreCase))
{
connName = null;
}
string sql = "Select top " + DEF_PAGE_SIZE.ToString() + " * From [" + tableName + "]";
DataSourceSchema ret = CreateTableSchema(tableName, connName, sql);
string dsId = tableName;
if (!string.IsNullOrEmpty(connName))
{
dsId = connName + "." + dsId;
}
DataSourceSchemaContainer.Instance().AddItem(dsId, ret);
return(ret);
}
