Свойство | Тип | Описание | |
---|---|---|---|
_connection | IDbConnection | ||
_connectionString | string | ||
_dialect |
Метод | Описание | |
---|---|---|
AddCheckConstraint ( string name, string table, string checkSql ) : void | ||
AddColumn ( string table, Column column ) : void | ||
AddColumn ( string table, string sqlColumn ) : void | ||
AddColumn ( string table, string column, DbType type ) : void |
|
|
AddColumn ( string table, string column, DbType type, ColumnProperty property ) : void |
|
|
AddColumn ( string table, string column, DbType type, int size ) : void |
|
|
AddColumn ( string table, string column, DbType type, int size, ColumnProperty property ) : void |
|
|
AddColumn ( string table, string column, DbType type, int size, ColumnProperty property, object defaultValue ) : void |
Add a new column to an existing table.
|
|
AddColumn ( string table, string column, DbType type, object defaultValue ) : void | ||
AddForeignKey ( string name, string primaryTable, string primaryColumn, string refTable, string refColumn ) : void |
Append a foreign key (relation) between two tables. tables.
|
|
AddForeignKey ( string name, string primaryTable, string primaryColumn, string refTable, string refColumn, Simple.Migrator.Framework.ForeignKeyConstraint constraint ) : void | ||
AddIndex ( string name, string table ) : void | ||
AddPrimaryKey ( string name, string table ) : void |
Append a primary key to a table.
|
|
AddTable ( string name ) : void |
Add a new table
|
|
AddTable ( string name, string engine ) : void |
Add a new table
|
|
AddTable ( string table, string engine, string columns ) : void | ||
AddUniqueConstraint ( string name, string table ) : void | ||
BeginTransaction ( ) : void |
Starts a transaction. Called by the migration mediator.
|
|
ChangeColumn ( string table, Column column ) : void | ||
ChangeColumn ( string table, string sqlColumn ) : void | ||
ColumnExists ( string table, string column ) : bool | ||
Commit ( ) : void |
Commit the current transaction. Called by the migrations mediator.
|
|
ConstraintExists ( string table, string name ) : bool |
Determines if a constraint exists.
|
|
Delete ( string table ) : int | ||
Delete ( string table, string columns, string values ) : int | ||
Dispose ( ) : void | ||
ExecuteNonQuery ( string sql ) : int | ||
ExecuteQuery ( string sql ) : IDataReader |
Execute an SQL query returning results.
|
|
ExecuteScalar ( string sql ) : object | ||
GenerateForeignKey ( string primaryTable, string refTable ) : void | ||
GenerateForeignKey ( string primaryTable, string refTable, Simple.Migrator.Framework.ForeignKeyConstraint constraint ) : void | ||
GenerateForeignKey ( string primaryTable, string primaryColumn, string refTable, string refColumn ) : void |
Guesses the name of the foreign key and add it
|
|
GenerateForeignKey ( string primaryTable, string primaryColumn, string refTable, string refColumn, Simple.Migrator.Framework.ForeignKeyConstraint constraint ) : void |
Guesses the name of the foreign key and add it
|
|
GetColumnByName ( string table, string columnName ) : Column | ||
GetColumns ( string table ) : Column[] | ||
GetCommand ( ) : IDbCommand | ||
GetPrimaryKeys ( IEnumerable |
||
GetTables ( ) : string[] | ||
Insert ( string table, string columns, string values ) : int | ||
IsThisProvider ( string provider ) : bool | ||
JoinColumnsAndValues ( string columns, string values ) : string | ||
MigrationApplied ( long version ) : void |
Marks a Migration version number as having been applied
|
|
MigrationUnApplied ( long version ) : void |
Marks a Migration version number as having been rolled back from the database
|
|
PrimaryKeyExists ( string table, string name ) : bool | ||
QuoteValues ( string values ) : string | ||
QuoteValues ( string values ) : string[] | ||
RemoveColumn ( string table, string column ) : void | ||
RemoveConstraint ( string table, string name ) : void | ||
RemoveForeignKey ( string table, string name ) : void | ||
RemoveIndex ( string name, string table ) : void | ||
RemoveTable ( string name ) : void | ||
RenameColumn ( string tableName, string oldColumnName, string newColumnName ) : void | ||
RenameTable ( string oldName, string newName ) : void | ||
Rollback ( ) : void |
Rollback the current migration. Called by the migration mediator.
|
|
SchemaInfoName ( string schemainfoname ) : void | ||
Select ( string what, string from ) : IDataReader | ||
Select ( string what, string from, string where ) : IDataReader | ||
Select ( string what, string from, string where, string orderBy ) : IDataReader | ||
SelectScalar ( string what, string from ) : object | ||
SelectScalar ( string what, string from, string where ) : object | ||
SelectScalar ( string what, string from, string where, string orderBy ) : object | ||
TableExists ( string table ) : bool | ||
Update ( string table, string columns, string values ) : int | ||
Update ( string table, string columns, string values, string where ) : int | ||
this ( string provider ) : ITransformationProvider |
Метод | Описание | |
---|---|---|
CreateSchemaInfoTable ( ) : void | ||
EnsureHasConnection ( ) : void | ||
JoinColumns ( IEnumerable |
||
JoinColumnsAndIndexes ( IEnumerable |
||
JoinIndexes ( IEnumerable |
||
TransformationProvider ( |
Метод | Описание | |
---|---|---|
BuildCommand ( string sql ) : IDbCommand |
public AddCheckConstraint ( string name, string table, string checkSql ) : void | ||
name | string | |
table | string | |
checkSql | string | |
Результат | void |
public AddColumn ( string table, Column column ) : void | ||
table | string | |
column | Column | |
Результат | void |
public AddColumn ( string table, string sqlColumn ) : void | ||
table | string | |
sqlColumn | string | |
Результат | void |
public AddColumn ( string table, string column, DbType type ) : void | ||
table | string | |
column | string | |
type | DbType | |
Результат | void |
public AddColumn ( string table, string column, DbType type, ColumnProperty property ) : void | ||
table | string | |
column | string | |
type | DbType | |
property | ColumnProperty | |
Результат | void |
public AddColumn ( string table, string column, DbType type, int size ) : void | ||
table | string | |
column | string | |
type | DbType | |
size | int | |
Результат | void |
public AddColumn ( string table, string column, DbType type, int size, ColumnProperty property ) : void | ||
table | string | |
column | string | |
type | DbType | |
size | int | |
property | ColumnProperty | |
Результат | void |
public AddColumn ( string table, string column, DbType type, int size, ColumnProperty property, object defaultValue ) : void | ||
table | string | Table to which to add the column |
column | string | Column name |
type | DbType | Date type of the column |
size | int | Max length of the column |
property | ColumnProperty | Properties of the column, see |
defaultValue | object | Default value |
Результат | void |
public AddColumn ( string table, string column, DbType type, object defaultValue ) : void | ||
table | string | |
column | string | |
type | DbType | |
defaultValue | object | |
Результат | void |
public AddForeignKey ( string name, string primaryTable, string primaryColumn, string refTable, string refColumn ) : void | ||
name | string | Constraint name |
primaryTable | string | Table name containing the primary key |
primaryColumn | string | Primary key column name |
refTable | string | Foreign table name |
refColumn | string | Foreign column name |
Результат | void |
public AddForeignKey ( string name, string primaryTable, string primaryColumn, string refTable, string refColumn, Simple.Migrator.Framework.ForeignKeyConstraint constraint ) : void | ||
name | string | |
primaryTable | string | |
primaryColumn | string | |
refTable | string | |
refColumn | string | |
constraint | Simple.Migrator.Framework.ForeignKeyConstraint | |
Результат | void |
public AddIndex ( string name, string table ) : void | ||
name | string | |
table | string | |
Результат | void |
public AddPrimaryKey ( string name, string table ) : void | ||
name | string | Constraint name |
table | string | Table name |
Результат | void |
public AddTable ( string name ) : void | ||
name | string | Table name |
Результат | void |
public AddTable ( string name, string engine ) : void | ||
name | string | Table name |
engine | string | the database storage engine to use |
Результат | void |
public AddTable ( string table, string engine, string columns ) : void | ||
table | string | |
engine | string | |
columns | string | |
Результат | void |
public AddUniqueConstraint ( string name, string table ) : void | ||
name | string | |
table | string | |
Результат | void |
public ChangeColumn ( string table, Column column ) : void | ||
table | string | |
column | Column | |
Результат | void |
public ChangeColumn ( string table, string sqlColumn ) : void | ||
table | string | |
sqlColumn | string | |
Результат | void |
public ColumnExists ( string table, string column ) : bool | ||
table | string | |
column | string | |
Результат | bool |
public abstract ConstraintExists ( string table, string name ) : bool | ||
table | string | Table owning the constraint |
name | string | Constraint name |
Результат | bool |
public Delete ( string table, string columns, string values ) : int | ||
table | string | |
columns | string | |
values | string | |
Результат | int |
public ExecuteNonQuery ( string sql ) : int | ||
sql | string | |
Результат | int |
public ExecuteQuery ( string sql ) : IDataReader | ||
sql | string | The SQL command. |
Результат | IDataReader |
public ExecuteScalar ( string sql ) : object | ||
sql | string | |
Результат | object |
public GenerateForeignKey ( string primaryTable, string refTable ) : void | ||
primaryTable | string | |
refTable | string | |
Результат | void |
public GenerateForeignKey ( string primaryTable, string refTable, Simple.Migrator.Framework.ForeignKeyConstraint constraint ) : void | ||
primaryTable | string | |
refTable | string | |
constraint | Simple.Migrator.Framework.ForeignKeyConstraint | |
Результат | void |
public GenerateForeignKey ( string primaryTable, string primaryColumn, string refTable, string refColumn ) : void | ||
primaryTable | string | |
primaryColumn | string | |
refTable | string | |
refColumn | string | |
Результат | void |
public GenerateForeignKey ( string primaryTable, string primaryColumn, string refTable, string refColumn, Simple.Migrator.Framework.ForeignKeyConstraint constraint ) : void | ||
primaryTable | string | |
primaryColumn | string | |
refTable | string | |
refColumn | string | |
constraint | Simple.Migrator.Framework.ForeignKeyConstraint | |
Результат | void |
public GetColumnByName ( string table, string columnName ) : Column | ||
table | string | |
columnName | string | |
Результат | Column |
public GetColumns ( string table ) : Column[] | ||
table | string | |
Результат | Column[] |
public GetPrimaryKeys ( IEnumerable |
||
columns | IEnumerable |
|
Результат | List |
public Insert ( string table, string columns, string values ) : int | ||
table | string | |
columns | string | |
values | string | |
Результат | int |
public IsThisProvider ( string provider ) : bool | ||
provider | string | |
Результат | bool |
protected JoinColumns ( IEnumerable |
||
columns | IEnumerable |
|
Результат | string |
protected JoinColumnsAndIndexes ( IEnumerable |
||
columns | IEnumerable |
|
Результат | string |
public JoinColumnsAndValues ( string columns, string values ) : string | ||
columns | string | |
values | string | |
Результат | string |
protected JoinIndexes ( IEnumerable |
||
columns | IEnumerable |
|
Результат | string |
public MigrationApplied ( long version ) : void | ||
version | long | The version number of the migration that was applied |
Результат | void |
public MigrationUnApplied ( long version ) : void | ||
version | long | The version number of the migration that was removed |
Результат | void |
public PrimaryKeyExists ( string table, string name ) : bool | ||
table | string | |
name | string | |
Результат | bool |
public QuoteValues ( string values ) : string | ||
values | string | |
Результат | string |
public QuoteValues ( string values ) : string[] | ||
values | string | |
Результат | string[] |
public RemoveColumn ( string table, string column ) : void | ||
table | string | |
column | string | |
Результат | void |
public RemoveConstraint ( string table, string name ) : void | ||
table | string | |
name | string | |
Результат | void |
public RemoveForeignKey ( string table, string name ) : void | ||
table | string | |
name | string | |
Результат | void |
public RemoveIndex ( string name, string table ) : void | ||
name | string | |
table | string | |
Результат | void |
public RenameColumn ( string tableName, string oldColumnName, string newColumnName ) : void | ||
tableName | string | |
oldColumnName | string | |
newColumnName | string | |
Результат | void |
public RenameTable ( string oldName, string newName ) : void | ||
oldName | string | |
newName | string | |
Результат | void |
public SchemaInfoName ( string schemainfoname ) : void | ||
schemainfoname | string | |
Результат | void |
public Select ( string what, string from ) : IDataReader | ||
what | string | |
from | string | |
Результат | IDataReader |
public Select ( string what, string from, string where ) : IDataReader | ||
what | string | |
from | string | |
where | string | |
Результат | IDataReader |
public Select ( string what, string from, string where, string orderBy ) : IDataReader | ||
what | string | |
from | string | |
where | string | |
orderBy | string | |
Результат | IDataReader |
public SelectScalar ( string what, string from ) : object | ||
what | string | |
from | string | |
Результат | object |
public SelectScalar ( string what, string from, string where ) : object | ||
what | string | |
from | string | |
where | string | |
Результат | object |
public SelectScalar ( string what, string from, string where, string orderBy ) : object | ||
what | string | |
from | string | |
where | string | |
orderBy | string | |
Результат | object |
public TableExists ( string table ) : bool | ||
table | string | |
Результат | bool |
protected TransformationProvider ( |
||
dialect | ||
invariantProvider | string | |
connectionString | string | |
Результат | System |
public Update ( string table, string columns, string values ) : int | ||
table | string | |
columns | string | |
values | string | |
Результат | int |
public Update ( string table, string columns, string values, string where ) : int | ||
table | string | |
columns | string | |
values | string | |
where | string | |
Результат | int |
public this ( string provider ) : ITransformationProvider | ||
provider | string | |
Результат | ITransformationProvider |