public SqlServerTableVM(SqlServerDataSource dataSource, SqlServerTableOrViewMetadata <SqlDbType> table) : base(dataSource, table)
{
FixItOperations.Add(new FixNulls(this));
FixItOperations.Add(new FixSparse(this));
FixItOperations.Add(new FixAddIdentityColumn(this));
FixItOperations.Add(new FixObsoleteTypes(this));
}
/// <summary>
/// Initializes a new instance of the <see cref="OleDbSqlServerDeleteSet" /> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="tableName">Name of the table.</param>
/// <param name="whereClause">The where clause.</param>
/// <param name="parameters">The parameters.</param>
/// <param name="expectedRowCount">The expected row count.</param>
/// <param name="options">The options.</param>
public OleDbSqlServerDeleteSet(OleDbSqlServerDataSourceBase dataSource, SqlServerObjectName tableName, string whereClause, IEnumerable <OleDbParameter> parameters, int?expectedRowCount, DeleteOptions options) : base(dataSource, whereClause, parameters, expectedRowCount, options)
{
if (options.HasFlag(DeleteOptions.UseKeyAttribute))
{
throw new NotSupportedException("Cannot use Key attributes with this operation.");
}
m_Table = dataSource.DatabaseMetadata.GetTableOrView(tableName);
}
/// <summary>
/// Initializes a new instance of the <see cref="OleDbSqlServerUpdateSet" /> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="tableName">Name of the table.</param>
/// <param name="newValues">The new values.</param>
/// <param name="options">The options.</param>
/// <exception cref="System.NotSupportedException">Cannot use Key attributes with this operation.</exception>
public OleDbSqlServerUpdateSet(OleDbSqlServerDataSourceBase dataSource, SqlServerObjectName tableName, object?newValues, UpdateOptions options) : base(dataSource)
{
if (options.HasFlag(UpdateOptions.UseKeyAttribute))
{
throw new NotSupportedException("Cannot use Key attributes with this operation.");
}
m_Table = dataSource.DatabaseMetadata.GetTableOrView(tableName);
m_NewValues = newValues;
m_Options = options;
}
/// <summary>
/// Initializes a new instance of the <see cref="OleDbSqlServerUpdateSet" /> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="tableName">Name of the table.</param>
/// <param name="updateExpression">The update expression.</param>
/// <param name="updateArgumentValue">The update argument value.</param>
/// <param name="options">The options.</param>
/// <exception cref="System.NotSupportedException">Cannot use Key attributes with this operation.</exception>
public OleDbSqlServerUpdateSet(OleDbSqlServerDataSourceBase dataSource, SqlServerObjectName tableName, string?updateExpression, object?updateArgumentValue, UpdateOptions options) : base(dataSource)
{
if (options.HasFlag(UpdateOptions.UseKeyAttribute))
{
throw new NotSupportedException("Cannot use Key attributes with this operation.");
}
m_Table = dataSource.DatabaseMetadata.GetTableOrView(tableName);
m_UpdateExpression = updateExpression;
m_Options = options;
m_UpdateArgumentValue = updateArgumentValue;
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlServerDeleteMany" /> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="tableName">Name of the table.</param>
/// <param name="whereClause">The where clause.</param>
/// <param name="parameters">The parameters.</param>
/// <param name="options">The options.</param>
public SqlServerDeleteMany(SqlServerDataSourceBase dataSource, SqlServerObjectName tableName, string whereClause, IEnumerable <SqlParameter> parameters, DeleteOptions options) : base(dataSource)
{
if (options.HasFlag(DeleteOptions.UseKeyAttribute))
{
throw new NotSupportedException("Cannot use Key attributes with this operation.");
}
m_Table = dataSource.DatabaseMetadata.GetTableOrView(tableName);
m_WhereClause = whereClause;
//m_Options = options;
m_Parameters = parameters;
}
/// <summary>
/// Initializes a new instance of the <see cref="OleDbSqlServerUpdateSet" /> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="tableName">Name of the table.</param>
/// <param name="newValues">The new values.</param>
/// <param name="whereClause">The where clause.</param>
/// <param name="parameters">The parameters.</param>
/// <param name="expectedRowCount">The expected row count.</param>
/// <param name="options">The options.</param>
public OleDbSqlServerUpdateSet(OleDbSqlServerDataSourceBase dataSource, SqlServerObjectName tableName, object?newValues, string?whereClause, IEnumerable <OleDbParameter> parameters, int?expectedRowCount, UpdateOptions options) : base(dataSource)
{
if (options.HasFlag(UpdateOptions.UseKeyAttribute))
{
throw new NotSupportedException("Cannot use Key attributes with this operation.");
}
m_Table = dataSource.DatabaseMetadata.GetTableOrView(tableName);
m_NewValues = newValues;
m_WhereClause = whereClause;
m_ExpectedRowCount = expectedRowCount;
m_Options = options;
m_Parameters = parameters;
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlServerDeleteMany"/> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="tableName">Name of the table.</param>
/// <param name="filterValue">The filter value.</param>
/// <param name="filterOptions">The options.</param>
public SqlServerDeleteMany(SqlServerDataSourceBase dataSource, SqlServerObjectName tableName, object filterValue, FilterOptions filterOptions) : base(dataSource)
{
m_Table = dataSource.DatabaseMetadata.GetTableOrView(tableName);
m_FilterValue = filterValue;
m_FilterOptions = filterOptions;
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlServerDeleteMany"/> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="tableName">Name of the table.</param>
/// <param name="whereClause">The where clause.</param>
/// <param name="argumentValue">The argument value.</param>
public SqlServerDeleteMany(SqlServerDataSourceBase dataSource, SqlServerObjectName tableName, string whereClause, object argumentValue) : base(dataSource)
{
m_Table = dataSource.DatabaseMetadata.GetTableOrView(tableName);
m_WhereClause = whereClause;
m_ArgumentValue = argumentValue;
}
/// <summary>
/// Initializes a new instance of the <see cref="OleDbSqlServerDeleteMany" /> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="tableName">Name of the table.</param>
/// <param name="whereClause">The where clause.</param>
/// <param name="parameters">The parameters.</param>
public OleDbSqlServerDeleteMany(OleDbSqlServerDataSourceBase dataSource, SqlServerObjectName tableName, string whereClause, IEnumerable <OleDbParameter> parameters) : base(dataSource)
{
m_Table = dataSource.DatabaseMetadata.GetTableOrView(tableName);
m_WhereClause = whereClause;
m_Parameters = parameters;
}
/// <summary>
/// Initializes a new instance of the <see cref="OleDbSqlServerDeleteSet"/> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="tableName">Name of the table.</param>
/// <param name="filterValue">The filter value.</param>
/// <param name="filterOptions">The options.</param>
public OleDbSqlServerDeleteSet(OleDbSqlServerDataSourceBase dataSource, SqlServerObjectName tableName, object filterValue, FilterOptions filterOptions) : base(dataSource, filterValue, filterOptions)
{
m_Table = dataSource.DatabaseMetadata.GetTableOrView(tableName);
}
/// <summary>
/// Initializes a new instance of the <see cref="OleDbSqlServerDeleteSet"/> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="tableName">Name of the table.</param>
/// <param name="whereClause">The where clause.</param>
/// <param name="argumentValue">The argument value.</param>
public OleDbSqlServerDeleteSet(OleDbSqlServerDataSourceBase dataSource, SqlServerObjectName tableName, string whereClause, object?argumentValue) : base(dataSource, whereClause, argumentValue)
{
m_Table = dataSource.DatabaseMetadata.GetTableOrView(tableName);
}
