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); }