public static List <SpMethod> GetSpMethod(SchemaExplorer.DatabaseSchema database)
{
List <SpMethod> ret = new List <SpMethod>();
foreach (CommandSchema comm in database.Commands)
{
if (IsCustomSp(comm.Name))
{
SpMethod item = new SpMethod();
item.Name = GetSpMethodName(comm.Name);
item.SpName = comm.Name;
item.ReturnTypeStr = GetSpMethodTypeStr(comm.Name);
item.ReturnType = GetSpMethodType(comm.Name);
item.Remark = GetSpRemark(comm);
item.EntityName = GetReturnValueName(comm.Name);
item.Paras = GetSpParas(comm);
ret.Add(item);
}
}
return(ret);
}
public TableSchema(DatabaseSchema database, string name, string owner, DateTime dateCreated, ExtendedProperty[] extendedProperties) : this(database, name, owner, dateCreated)
{
this._defaultExtendedProperties = extendedProperties;
base._extendedProperties = new ExtendedPropertyCollection(extendedProperties);
}
/// <summary>
/// Gets all commands for the given database.
/// </summary>
/// <param name="connectionString">The connection string used to connect to the target database.</param>
/// <param name="database"></param>
/// <returns></returns>
public CommandSchema[] GetCommands(string connectionString, DatabaseSchema database)
{
return(new CommandSchema[0]);
}
/// <summary>
/// Gets all the views available for a given database.
/// Used by CodeSmith studio test button, so also try to open a connection
/// </summary>
/// <param name="connectionString">The connection string used to connect to the target database.</param>
/// <param name="database"></param>
/// <returns></returns>
public ViewSchema[] GetViews(string connectionString, DatabaseSchema database)
{
GetConnection(connectionString);
return(new ViewSchema[0]);
}
public CommandSchema[] GetCommands(string connectionString, DatabaseSchema database)
{
//SQLite doesn't support stored commands eg stored procs
return(new CommandSchema[0]);
}
public TableKeySchema(DatabaseSchema database, string name, string[] foreignKeyMemberColumns, string foreignKeyTableOwner, string foreignKeyTable, string[] primaryKeyMemberColumns, string primaryKeyTableOwner, string primaryKeyTable, ExtendedProperty[] extendedProperties) : this(database, name, foreignKeyMemberColumns, foreignKeyTableOwner, foreignKeyTable, primaryKeyMemberColumns, primaryKeyTableOwner, primaryKeyTable)
{
this._defaultExtendedProperties = extendedProperties;
base._extendedProperties = new ExtendedPropertyCollection(extendedProperties);
}
public TableKeySchema(DatabaseSchema database, string name, string[] foreignKeyMemberColumns, string foreignKeyTable, string[] primaryKeyMemberColumns, string primaryKeyTable) : this(database, name, foreignKeyMemberColumns, string.Empty, foreignKeyTable, primaryKeyMemberColumns, string.Empty, primaryKeyTable)
{
}
