ADO.NET - 1.1
Description
This extension provides support for SQL query execution calls under ADO.NET using C# language.
Function Point, Quality and Sizing support
- Function Points (transactions): a green tick indicates that OMG Function Point counting and Transaction Risk Index are supported
- Quality and Sizing: a green tick indicates that CAST can measure size and that a minimum set of Quality Rules exist
| Function Points (transactions) | Quality and Sizing |
|---|---|
| ✅ | ❌ |
Supported ADO.NET data providers
All supported methods/properties below are used to execute SQL queries on their corresponding server. Other API methods are considered internally so that the query statements are correctly evaluated.
IBM
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| IBM | IBM.Data.DB2 (Db2 .NET Provider) |
IBM.Data.DB2.DB2Command.ExecuteReader |
IBM.Data.DB2.DB2Command.CommandText | ||
IBM.Data.DB2.DB2Command.ExecutePageReader | |||||
IBM.Data.DB2.DB2Command.ExecuteNonQuery | |||||
IBM.Data.DB2.DB2Command.ExecuteResultSet | |||||
IBM.Data.DB2.DB2Command.ExecuteScalar | |||||
IBM.Data.DB2.DB2Command.ExecuteXmlReader | |||||
IBM.Data.DB2.DB2Command.ExecuteRow | |||||
| IBM.Data.DB2.DB2DataAdapter.Fill | IBM.Data.DB2.DB2DataAdapter.SelectCommand | ||||
| IBM.Data.DB2.DB2DataAdapter.FillSchema | |||||
IBM.Data.DB2.DB2DataAdapter.Update | IBM.Data.DB2.DB2DataAdapter.InsertCommand IBM.Data.DB2.DB2DataAdapter.UpdateCommand IBM.Data.DB2.DB2DataAdapter.DeleteCommand | ||||
IBM.Data.DB2.Core (Db2 .NET Provider for .NET Core) |
IBM.Data.DB2.Core.DB2Command.ExecuteReader | IBM.Data.DB2.Core.DB2Command.CommandText | |||
IBM.Data.DB2.Core.DB2Command.ExecutePageReader | |||||
IBM.Data.DB2.Core.DB2Command.ExecuteNonQuery | |||||
IBM.Data.DB2.Core.DB2Command.ExecuteResultSet | |||||
IBM.Data.DB2.Core.DB2Command.ExecuteScalar | |||||
IBM.Data.DB2.Core.DB2Command.ExecuteXmlReader | |||||
IBM.Data.DB2.Core.DB2Command.ExecuteRow | |||||
IBM.Data.DB2.Core.DB2BulkCopy.WriteToServer | IBM.Data.DB2.Core.DB2BulkCopy.DestinationTableName | ||||
IBM.Data.DB2.Core.DB2DataAdapter.Fill | IBM.Data.DB2.Core.DB2DataAdapter.SelectCommand | ||||
IBM.Data.DB2.Core.DB2DataAdapter.FillSchema | |||||
IBM.Data.DB2.Core.DB2DataAdapter.Update | IBM.Data.DB2.Core.DB2DataAdapter.InsertCommand IBM.Data.DB2.Core.DB2DataAdapter.UpdateCommand IBM.Data.DB2.Core.DB2DataAdapter.DeleteCommand | ||||
IBM.Data.DB2.iSeries (IBM iSeries Db2 .NET Provider) |
IBM.Data.DB2.iSeries.iDB2Command.ExecuteReader | IBM.Data.DB2.iSeries.iDB2Command.CommandText | |||
IBM.Data.DB2.iSeries.iDB2Command.ExecuteNonQuery | |||||
IBM.Data.DB2.iSeries.iDB2Command.ExecuteScalar | |||||
IBM.Data.DB2.iSeries.iDB2Command.ExecuteXmlReader | |||||
IBM.Data.DB2.iSeries.iDB2DataAdapter.Fill | IBM.Data.DB2.iSeries.iDB2DataAdapter.SelectCommand | ||||
IBM.Data.DB2.iSeries.iDB2DataAdapter.FillSchema | |||||
IBM.Data.DB2.iSeries.iDB2DataAdapter.Update | IBM.Data.DB2.iSeries.iDB2DataAdapter.InsertCommand IBM.Data.DB2.iSeries.iDB2DataAdapter.UpdateCommand IBM.Data.DB2.iSeries.iDB2DataAdapter.DeleteCommand | ||||
IBM.Data.Informix (IBM Informix .NET Provider) |
IBM.Data.Informix.IfxCommand.ExecuteReader | IBM.Data.Informix.IfxCommand.CommandText | |||
IBM.Data.Informix.IfxCommand.ExecuteNonQuery | |||||
IBM.Data.Informix.IfxCommand.ExecuteScalar |
Microsoft
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| Microsoft | Microsoft.Data.SqlClient (.NET Data Provider for SQL Server) |
Microsoft.Data.SqlClient.SqlCommand.ExecuteReader | Microsoft.Data.SqlClient.SqlCommand.CommandText | ||
Microsoft.Data.SqlClient.SqlCommand.ExecuteReaderAsync | |||||
Microsoft.Data.SqlClient.SqlCommand.BeginExecuteReader | |||||
Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery | |||||
Microsoft.Data.SqlClient.SqlCommand.BeginExecuteNonQuery | |||||
Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQueryAsync | |||||
Microsoft.Data.SqlClient.SqlCommand.ExecuteScalar | |||||
Microsoft.Data.SqlClient.SqlCommand.ExecuteScalarAsync | |||||
Microsoft.Data.SqlClient.SqlCommand.ExecuteXmlReader | |||||
Microsoft.Data.SqlClient.SqlCommand.ExecuteXmlReaderAsync | |||||
Microsoft.Data.SqlClient.SqlCommand.BeginExecuteXmlReader | |||||
| Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServer | Microsoft.Data.SqlClient.SqlBulkCopy.DestinationTableName | ||||
| Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerAsync | |||||
Microsoft.Data.SqlClient.SqlDataAdapter.Fill | Microsoft.Data.SqlClient.SqlDataAdapter.SelectCommand | ||||
Microsoft.Data.SqlClient.SqlDataAdapter.FillSchema | |||||
Microsoft.Data.SqlClient.SqlDataAdapter.Update | Microsoft.Data.SqlClient.SqlDataAdapter.InsertCommand Microsoft.Data.SqlClient.SqlDataAdapter.UpdateCommand Microsoft.Data.SqlClient.SqlDataAdapter.DeleteCommand | ||||
Microsoft.Data.Sqlite (.NET Data Provider for SQLite) |
Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader | Microsoft.Data.Sqlite.SqliteCommand.CommandText | |||
Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync | |||||
Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery | |||||
Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQueryAsync | |||||
Microsoft.Data.Sqlite.SqliteCommand.ExecuteScalar | |||||
Microsoft.Data.Sqlite.SqliteCommand.ExecuteScalarAsync | |||||
System.Data.SqlClient (.NET Data Provider for SQL Server) |
System.Data.SqlClient.SqlCommand.ExecuteReader | System.Data.SqlClient.SqlCommand.CommandText | |||
System.Data.SqlClient.SqlCommand.ExecuteReaderAsync | |||||
System.Data.SqlClient.SqlCommand.BeginExecuteReader | |||||
System.Data.SqlClient.SqlCommand.ExecuteNonQuery | |||||
System.Data.SqlClient.SqlCommand.BeginExecuteNonQuery | |||||
System.Data.SqlClient.SqlCommand.ExecuteNonQueryAsync | |||||
System.Data.SqlClient.SqlCommand.ExecuteScalar | |||||
System.Data.SqlClient.SqlCommand.ExecuteScalarAsync | |||||
System.Data.SqlClient.SqlCommand.ExecuteXmlReader | |||||
System.Data.SqlClient.SqlCommand.ExecuteXmlReaderAsync | |||||
System.Data.SqlClient.SqlCommand.BeginExecuteXmlReader | |||||
| System.Data.SqlClient.SqlBulkCopy.WriteToServer | System.Data.SqlClient.SqlBulkCopy.DestinationTableName | ||||
| System.Data.SqlClient.SqlBulkCopy.WriteToServerAsync | |||||
System.Data.SqlClient.SqlDataAdapter.Fill | System.Data.SqlClient.SqlDataAdapter.SelectCommand | ||||
System.Data.SqlClient.SqlDataAdapter.FillSchema | |||||
System.Data.SqlClient.SqlDataAdapter.Update | System.Data.SqlClient.SqlDataAdapter.InsertCommand System.Data.SqlClient.SqlDataAdapter.UpdateCommand System.Data.SqlClient.SqlDataAdapter.DeleteCommand | ||||
System.Data.SQLite (.NET Data Provider for SQLite) |
System.Data.SQLite.SQLiteCommand.ExecuteReader | System.Data.SQLite.SQLiteCommand.CommandText | |||
System.Data.SQLite.SQLiteCommand.ExecuteReaderAsync | |||||
System.Data.SQLite.SQLiteCommand.ExecuteNonQuery | |||||
System.Data.SQLite.SQLiteCommand.ExecuteNonQueryAsync | |||||
System.Data.SQLite.SQLiteCommand.ExecuteScalar | |||||
System.Data.SQLite.SQLiteCommand.ExecuteScalarAsync | |||||
System.Data.SQLite.SQLiteCommand.Execute | |||||
System.Data.SQLite.SQLiteDataAdapter.Fill | System.Data.SQLite.SQLiteDataAdapter.SelectCommand | ||||
System.Data.SQLite.SQLiteDataAdapter.FillSchema | |||||
System.Data.SQLite.SQLiteDataAdapter.Update | System.Data.SQLite.SQLiteDataAdapter.InsertCommand System.Data.SQLite.SQLiteDataAdapter.UpdateCommand System.Data.SQLite.SQLiteDataAdapter.DeleteCommand | ||||
System.Data.OracleClient (.NET Data Provider for Oracle) |
System.Data.OracleClient.OracleCommand.ExecuteReader | System.Data.OracleClient.OracleCommand.CommandText | |||
System.Data.OracleClient.OracleCommand.ExecuteReaderAsync | |||||
System.Data.OracleClient.OracleCommand.ExecuteNonQuery | |||||
System.Data.OracleClient.OracleCommand.ExecuteOracleNonQuery | |||||
System.Data.OracleClient.OracleCommand.ExecuteNonQueryAsync | |||||
System.Data.OracleClient.OracleCommand.ExecuteScalar | |||||
System.Data.OracleClient.OracleCommand.ExecuteOracleScalar | |||||
System.Data.OracleClient.OracleCommand.ExecuteScalarAsync | |||||
System.Data.OracleClient.OracleDataAdapter.Fill | System.Data.OracleClient.OracleDataAdapter.SelectCommand | ||||
System.Data.OracleClient.OracleDataAdapter.FillSchema | |||||
System.Data.OracleClient.OracleDataAdapter.Update | System.Data.OracleClient.OracleDataAdapter.InsertCommand System.Data.OracleClient.OracleDataAdapter.UpdateCommand System.Data.OracleClient.OracleDataAdapter.DeleteCommand | ||||
System.Data.OleDb (.NET Data Provider for OLE DB) |
System.Data.OleDb.OleDbCommand.ExecuteReader | System.Data.OleDb.OleDbCommand.CommandText System.Data.OleDb.OleDbCommand.CommandType |
CommandType.Text CommandType.TableDirect CommandType.StoredProcedure |
||
System.Data.OleDb.OleDbCommand.ExecuteReaderAsync | |||||
System.Data.OleDb.OleDbCommand.ExecuteNonQuery | |||||
System.Data.OleDb.OleDbCommand.ExecuteNonQueryAsync | |||||
System.Data.OleDb.OleDbCommand.ExecuteScalar | |||||
System.Data.OleDb.OleDbCommand.ExecuteScalarAsync | |||||
System.Data.OleDb.OleDbDataAdapter.Fill | System.Data.OleDb.OleDbDataAdapter.SelectCommand | ||||
System.Data.OleDb.OleDbDataAdapter.FillSchema | |||||
System.Data.OleDb.OleDbDataAdapter.Update | System.Data.OleDb.OleDbDataAdapter.InsertCommand System.Data.OleDb.OleDbDataAdapter.UpdateCommand System.Data.OleDb.OleDbDataAdapter.DeleteCommand | ||||
System.Data.Odbc (.NET Data Provider for ODBC) |
System.Data.Odbc.OdbcCommand.ExecuteReader | System.Data.Odbc.OdbcCommand.CommandText | |||
System.Data.Odbc.OdbcCommand.ExecuteReaderAsync | |||||
System.Data.Odbc.OdbcCommand.ExecuteNonQuery | |||||
System.Data.Odbc.OdbcCommand.ExecuteNonQueryAsync | |||||
System.Data.Odbc.OdbcCommand.ExecuteScalar | |||||
System.Data.Odbc.OdbcCommand.ExecuteScalarAsync | |||||
System.Data.Odbc.OdbcDataAdapter.Fill | System.Data.Odbc.OdbcDataAdapter.SelectCommand | ||||
| System.Data.Odbc.OdbcDataAdapter.FillSchema | |||||
System.Data.Odbc.OdbcDataAdapter.Update | System.Data.Odbc.OdbcDataAdapter.InsertCommand System.Data.Odbc.OdbcDataAdapter.UpdateCommand System.Data.Odbc.OdbcDataAdapter.DeleteCommand | ||||
System.Data.EntityClient (.NET Data Provider for Entity Framework) |
System.Data.EntityClient.EntityCommand.ExecuteReader | System.Data.EntityClient.EntityCommand.CommandText | |||
System.Data.EntityClient.EntityCommand.ExecuteNonQuery | |||||
System.Data.EntityClient.EntityCommand.ExecuteScalar | |||||
System.Data.Entity.Core.EntityClient (.NET Core Data Provider for Entity Framework) |
System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteReader | System.Data.Entity.Core.EntityClient.EntityCommand.CommandText | |||
System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteReaderAsync | |||||
System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteScalar | |||||
System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteNonQuery | |||||
System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteNonQueryAsync | |||||
System.Data.SqlServerCe (.NET Data Provider for SQL Server Compact) |
System.Data.SqlServerCe.SqlCeCommand.ExecuteReader | System.Data.SqlServerCe.SqlCeCommand.CommandText System.Data.SqlServerCe.SqlCeCommand.CommandType |
CommandType.Text CommandType.TableDirect CommandType.StoredProcedure |
||
System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery | |||||
System.Data.SqlServerCe.SqlCeCommand.ExecuteScalar | |||||
System.Data.SqlServerCe.SqlCeCommand.ExecuteResultSet | |||||
System.Data.Common (ADO.NET Common Provider Interfaces) |
System.Data.Common.DbCommand.ExecuteReader | System.Data.Common.DbCommand.CommandText | |||
System.Data.Common.DbCommand.ExecuteReaderAsync | |||||
System.Data.Common.DbCommand.ExecuteNonQuery | |||||
System.Data.Common.DbCommand.ExecuteNonQueryAsync | |||||
System.Data.Common.DbCommand.ExecuteScalar | |||||
System.Data.Common.DbCommand.ExecuteScalarAsync | |||||
System.Data.Common.DbBatch.ExecuteReader | System.Data.Common.DbBatchCommand.CommandText | ||||
System.Data.Common.DbBatch.ExecuteReaderAsync | |||||
System.Data.Common.DbBatch.ExecuteNonQuery | |||||
System.Data.Common.DbBatch.ExecuteNonQueryAsync | |||||
System.Data.Common.DbBatch.ExecuteScalar | |||||
System.Data.Common.DbBatch.ExecuteScalarAsync | |||||
System.Data.Common.DbDataAdapter.Fill | System.Data.Common.DbDataAdapter.SelectCommand | ||||
System.Data.Common.DbDataAdapter.FillSchema | |||||
System.Data.Common.DbDataAdapter.Update | System.Data.Common.DbDataAdapter.InsertCommand System.Data.Common.DbDataAdapter.UpdateCommand System.Data.Common.DbDataAdapter.DeleteCommand | ||||
System.Data.Linq (.NET Data Provider for LINQ to SQL) |
System.Data.Linq.DataContext.ExecuteCommand |
System.Data.Linq.Mapping.TableAttribute System.Data.Linq.DataContext.GetTable |
|||
System.Data.Linq.DataContext.ExecuteQuery | |||||
System.Data.Linq.Table.InsertOnSubmit | TEntity | ||||
System.Data.Linq.Table.InsertAllOnSubmit | IEnumerable | ||||
System.Data.Linq.Table.DeleteOnSubmit | TEntity | ||||
System.Data.Linq.Table.DeleteAllOnSubmit | IEnumerable | ||||
System.Data.Linq.Table.GetEnumerator | |||||
System.Linq (.NET Data Provider for LINQ to SQL) |
System.Linq.Enumerable.ToArray | ||||
System.Linq.Enumerable.ToList | |||||
System.Linq.Enumerable.ToDictionary | |||||
System.Linq.Enumerable.ToHashSet | |||||
System.Linq.Enumerable.ToLookup | |||||
System.Linq.Queryable.All | |||||
System.Linq.Queryable.Any | |||||
System.Linq.Queryable.Average | |||||
System.Linq.Queryable.Contains | |||||
System.Linq.Queryable.Count | |||||
System.Linq.Queryable.ElementAt | |||||
System.Linq.Queryable.ElementAtOrDefault | |||||
System.Linq.Queryable.First | |||||
System.Linq.Queryable.FirstOrDefault | |||||
System.Linq.Queryable.Last | |||||
System.Linq.Queryable.LastOrDefault | |||||
System.Linq.Queryable.LongCount | |||||
System.Linq.Queryable.Max | |||||
System.Linq.Queryable.Min | |||||
System.Linq.Queryable.Single | |||||
System.Linq.Queryable.SingleOrDefault | |||||
System.Linq.Queryable.Sum |
MySQL
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| MySQL | MySql.Data.MySqlClient (MySQL Connector/NET) |
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader | MySql.Data.MySqlClient.MySqlCommand.CommandText | ||
MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync | |||||
MySql.Data.MySqlClient.MySqlCommand.BeginExecuteReader | |||||
MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery | |||||
MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQueryAsync | |||||
MySql.Data.MySqlClient.MySqlCommand.BeginExecuteNonQuery | |||||
MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar | |||||
MySql.Data.MySqlClient.MySqlCommand.ExecuteScalarAsync | |||||
MySql.Data.MySqlClient.MySqlDataAdapter.Fill | MySql.Data.MySqlClient.MySqlDataAdapter.SelectCommand | ||||
MySql.Data.MySqlClient.MySqlDataAdapter.FillSchema | |||||
MySql.Data.MySqlClient.MySqlDataAdapter.Update | MySql.Data.MySqlClient.MySqlDataAdapter.InsertCommand MySql.Data.MySqlClient.MySqlDataAdapter.UpdateCommand MySql.Data.MySqlClient.MySqlDataAdapter.DeleteCommand | ||||
MySqlConnector (MySqlConnector ADO.NET provider) |
MySqlConnector.MySqlCommand.ExecuteReader | MySqlConnector.MySqlCommand.CommandText | |||
MySqlConnector.MySqlCommand.ExecuteReaderAsync | |||||
MySqlConnector.MySqlCommand.ExecuteNonQuery | |||||
MySqlConnector.MySqlCommand.ExecuteNonQueryAsync | |||||
MySqlConnector.MySqlCommand.ExecuteScalar | |||||
MySqlConnector.MySqlCommand.ExecuteScalarAsync | |||||
MySqlConnector.MySqlBatch.ExecuteReader | MySqlConnector.MySqlBatch.BatchCommands | ||||
MySqlConnector.MySqlBatch.ExecuteReaderAsync | |||||
MySqlConnector.MySqlBatch.ExecuteNonQuery | |||||
MySqlConnector.MySqlBatch.ExecuteNonQueryAsync | |||||
MySqlConnector.MySqlBatch.ExecuteScalar | |||||
MySqlConnector.MySqlBatch.ExecuteScalarAsync | |||||
| MySqlConnector.MySqlBulkCopy.WriteToServer | MySqlConnector.MySqlBulkCopy.DestinationTableName | ||||
| MySqlConnector.MySqlBulkCopy.WriteToServerAsync | |||||
| MySqlConnector.MySqlBulkLoader.Load | MySqlConnector.MySqlBulkLoader.TableName | ||||
| MySqlConnector.MySqlBulkLoader.LoadAsync | |||||
MySqlConnector.MySqlDataAdapter.Fill | MySqlConnector.MySqlDataAdapter.SelectCommand | ||||
MySqlConnector.MySqlDataAdapter.FillSchema | |||||
MySqlConnector.MySqlDataAdapter.Update | MySqlConnector.MySqlDataAdapter.InsertCommand MySqlConnector.MySqlDataAdapter.UpdateCommand MySqlConnector.MySqlDataAdapter.DeleteCommand |
Oracle Server
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| Oracle Server | Oracle.DataAccess.Client (Oracle Data Provider for .NET - Unmanaged Driver) |
Oracle.DataAccess.Client.OracleCommand.ExecuteReader | Oracle.DataAccess.Client.OracleCommand.CommandText | ||
Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery | |||||
Oracle.DataAccess.Client.OracleCommand.ExecuteScalar | |||||
Oracle.DataAccess.Client.OracleCommand.ExecuteXmlReader | |||||
Oracle.DataAccess.Client.OracleCommand.ExecuteStream | |||||
Oracle.DataAccess.Client.OracleCommand.ExecuteToStream | |||||
| Oracle.DataAccess.Client.OracleBulkCopy.WriteToServer | Oracle.DataAccess.Client.OracleBulkCopy.DestinationTableName | ||||
Oracle.DataAccess.Client.OracleDataAdapter.Fill | Oracle.DataAccess.Client.OracleDataAdapter.SelectCommand | ||||
| Oracle.DataAccess.Client.OracleDataAdapter.FillSchema | |||||
Oracle.DataAccess.Client.OracleDataAdapter.Update | Oracle.DataAccess.Client.OracleDataAdapter.InsertCommand Oracle.DataAccess.Client.OracleDataAdapter.UpdateCommand Oracle.DataAccess.Client.OracleDataAdapter.DeleteCommand | ||||
Oracle.ManagedDataAccess.Client (Oracle Data Provider for .NET - Managed Driver) |
Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader | Oracle.ManagedDataAccess.Client.OracleCommand.CommandText | |||
Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery | |||||
Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteScalar | |||||
Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteXmlReader | |||||
Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteStream | |||||
Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteToStream | |||||
| Oracle.ManagedDataAccess.Client.OracleBulkCopy.WriteToServer | Oracle.ManagedDataAccess.Client.OracleBulkCopy.DestinationTableName | ||||
Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill | Oracle.ManagedDataAccess.Client.OracleDataAdapter.SelectCommand | ||||
Oracle.ManagedDataAccess.Client.OracleDataAdapter.FillSchema | |||||
Oracle.ManagedDataAccess.Client.OracleDataAdapter.Update | Oracle.ManagedDataAccess.Client.OracleDataAdapter.InsertCommand Oracle.ManagedDataAccess.Client.OracleDataAdapter.UpdateCommand Oracle.ManagedDataAccess.Client.OracleDataAdapter.DeleteCommand |
Devart
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| Devart | Devart.Common (Devart’s dotConnect) |
Devart.Common.DbCommandBase.ExecutePageReader | Devart.Common.DbCommandBase.CommandText | ||
Devart.Common.DbCommandBase.BeginExecuteReader | |||||
Devart.Common.DbCommandBase.ExecuteNonQuery | |||||
Devart.Common.DbCommandBase.BeginExecuteNonQuery | |||||
Devart.Common.DbCommandBase.ExecuteScalar | |||||
Devart.Common.SqlStatement.Execute | Devart.Common.SqlStatement.Text | ||||
Devart.Common.SqlStatement.ExecuteNonQuery | |||||
Devart.Common.DbScript.Execute | |||||
Devart.Common.DbScript.ExecuteNext | |||||
Devart.Common.DbDataAdapter.FillPage | Devart.Common.DbDataAdapter.SelectCommand | ||||
Devart.Data.Oracle (Devart’s dotConnect for Oracle) |
Devart.Data.Oracle.OracleCommand.ExecuteReader | Devart.Data.Oracle.OracleCommand.CommandText | |||
Devart.Data.Oracle.OracleCommand.ExecutePageReader | |||||
Devart.Data.Oracle.OracleCommand.ExecuteNonQuery | |||||
Devart.Data.Oracle.OracleCommand.ExecuteScalar | |||||
Devart.Data.Oracle.OracleCommand.ExecuteArray | |||||
Devart.Data.Oracle.OracleDataAdapter.Fill | Devart.Data.Oracle.OracleDataAdapter.SelectCommand | ||||
Devart.Data.Oracle.OracleDataAdapter.FillPage | |||||
Devart.Data.Oracle.OracleDataAdapter.FillSchema | |||||
Devart.Data.Oracle.OracleDataAdapter.Update | Devart.Data.Oracle.OracleDataAdapter.InsertCommand Devart.Data.Oracle.OracleDataAdapter.UpdateCommand Devart.Data.Oracle.OracleDataAdapter.DeleteCommand | ||||
Devart.Data.MySql (Devart’s dotConnect for MySql) |
Devart.Data.MySql.MySqlCommand.ExecuteReader | Devart.Data.MySql.MySqlCommand.CommandText | |||
| Devart.Data.MySql.MySqlCommand.BeginExecuteReader | |||||
| Devart.Data.MySql.MySqlCommand.ExecutePageReader | |||||
| Devart.Data.MySql.MySqlHelper.ExecuteReader | |||||
| Devart.Data.MySql.MySqlHelper.ExecuteNonQuery | |||||
| Devart.Data.MySql.MySqlHelper.ExecuteScalar | |||||
| Devart.Data.MySql.MySqlStatement.Execute | |||||
| (Overriden from Devart.Common) | Devart.Data.MySql.MySqlScript.ScriptText | ||||
| Devart.Data.MySql.MySqlDataAdapter.Fill | Devart.Data.MySql.MySqlDataAdapter.SelectCommand | ||||
| Devart.Data.MySql.MySqlDataAdapter.FillPage | |||||
| Devart.Data.MySql.MySqlDataAdapter.FillSchema | |||||
| Devart.Data.MySql.MySqlDataAdapter.Update | Devart.Data.MySql.MySqlDataAdapter.InsertCommand Devart.Data.MySql.MySqlDataAdapter.UpdateCommand Devart.Data.MySql.MySqlDataAdapter.DeleteCommand | ||||
Devart.Data.SQLite (Devart’s dotConnect for SQLite) |
Devart.Data.SQLite.SQLiteCommand.ExecuteReader | Devart.Data.SQLite.SQLiteCommand.CommandText | |||
| Devart.Data.SQLite.SQLiteCommand.ExecutePageReader | |||||
(Overriden from Devart.Common) | Devart.Data.SQLite.SQLiteScript.ScriptText | ||||
| (Overriden from System.Data.Common) | Devart.Data.SQLite.SQLiteDataAdapter.SelectCommand Devart.Data.SQLite.SQLiteDataAdapter.UpdateCommand Devart.Data.SQLite.SQLiteDataAdapter.InsertCommand Devart.Data.SQLite.SQLiteDataAdapter.DeleteCommand | ||||
Devart.Data.PostgreSql (Devart’s dotConnect for PostgreSql) |
Devart.Data.PostgreSql.PgSqlCommand.ExecuteReader | Devart.Data.PostgreSql.PgSqlCommand.CommandText | |||
Devart.Data.PostgreSql.PgSqlCommand.ExecutePageReader | |||||
| (Overriden from Devart.Common) | Devart.Data.PostgreSql.PgSqlScript.ScriptText | ||||
| (Overriden from System.Data.Common) | Devart.Data.PostgreSql.PgSqlDataAdapter.SelectCommand Devart.Data.PostgreSql.PgSqlDataAdapter.UpdateCommand Devart.Data.PostgreSql.PgSqlDataAdapter.InsertCommand Devart.Data.PostgreSql.PgSqlDataAdapter.DeleteCommand | ||||
Devart.Data.Linq (Devart’s dotConnect for LINQ to SQL) |
Devart.Data.Linq.DataContext.ExecuteCommand | ||||
Devart.Data.Linq.DataContext.ExecuteQuery |
PostgreSQL
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| PostgreSQL | Npgsql (.NET Data Provider for PostgreSQL) |
Npgsql.NpgsqlCommand.ExecuteReader | Npgsql.NpgsqlCommand.CommandText | ||
Npgsql.NpgsqlCommand.ExecuteReaderAsync | |||||
Npgsql.NpgsqlCommand.ExecuteNonQuery | |||||
Npgsql.NpgsqlCommand.ExecuteNonQueryAsync | |||||
Npgsql.NpgsqlCommand.ExecuteScalar | |||||
Npgsql.NpgsqlCommand.ExecuteScalarAsync | |||||
Npgsql.NpgsqlBatch.ExecuteReader | Npgsql.NpgsqlBatch.BatchCommands | ||||
Npgsql.NpgsqlBatch.ExecuteReaderAsync | |||||
Npgsql.NpgsqlBatch.ExecuteNonQuery | |||||
Npgsql.NpgsqlBatch.ExecuteNonQueryAsync | |||||
Npgsql.NpgsqlBatch.ExecuteScalar | |||||
Npgsql.NpgsqlBatch.ExecuteScalarAsync | |||||
Npgsql.NpgsqlDataAdapter.Fill | Npgsql.NpgsqlDataAdapter.SelectCommand | ||||
Npgsql.NpgsqlDataAdapter.FillSchema | |||||
Npgsql.NpgsqlDataAdapter.Update | Npgsql.NpgsqlDataAdapter.InsertCommand Npgsql.NpgsqlDataAdapter.UpdateCommand Npgsql.NpgsqlDataAdapter.DeleteCommand |
Praeclarum
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| Praeclarum | SQLite (Praeclarum SQLite ADO.NET Provider) |
SQLite.SQLiteCommand.ExecuteQuery | SQLite.SQLiteCommand.CommandText |
||
SQLite.SQLiteCommand.ExecuteDeferredQuery | |||||
SQLite.SQLiteCommand.ExecuteNonQuery | |||||
SQLite.SQLiteCommand.ExecuteScalar | |||||
SQLite.SQLiteCommand.ExecuteQueryScalars | |||||
SQLite.SQLiteConnection.Execute |
string params object[] |
SQLite.TableAttribute SQLite.SQLiteConnection.Table SQLite.SQLiteAsyncConnection.Table |
|||
SQLite.SQLiteConnection.ExecuteScalar | string params object[] | ||||
SQLite.SQLiteConnection.Query | string params object[] | ||||
SQLite.SQLiteConnection.QueryScalars | string params object[] | ||||
SQLite.SQLiteConnection.DeferredQuery | string params object[] | ||||
SQLite.SQLiteConnection.GetTableInfo | string | ||||
SQLite.SQLiteConnection.DropTable | |||||
SQLite.SQLiteConnection.CreateTable | |||||
SQLite.SQLiteConnection.CreateTables | CreateFlags | ||||
SQLite.SQLiteConnection.Get |
object | ||||
object TableMapping | |||||
SQLite.SQLiteConnection.Find |
object | ||||
object TableMapping | |||||
SQLite.SQLiteConnection.FindWithQuery |
string params object[] | ||||
TableMapping string params object[] | |||||
SQLite.SQLiteConnection.Insert |
object | ||||
object Type | |||||
object string | |||||
object string Type | |||||
SQLite.SQLiteConnection.InsertAll |
IEnumerable bool | ||||
IEnumerable string extra bool | |||||
IEnumerable Type bool | |||||
SQLite.SQLiteConnection.InsertOrReplace |
object | ||||
object Type | |||||
SQLite.SQLiteConnection.Update |
object | ||||
object Type | |||||
SQLite.SQLiteConnection.UpdateAll | IEnumerable bool | ||||
SQLite.SQLiteConnection.Delete | object | ||||
SQLite.SQLiteConnection.DeleteAll | |||||
SQLite.SQLiteAsyncConnection.CreateTableAsync | |||||
SQLite.SQLiteAsyncConnection.CreateTablesAsync | CreateFlags | ||||
SQLite.SQLiteAsyncConnection.DropTableAsync | |||||
SQLite.SQLiteAsyncConnection.InsertAsync |
object | ||||
object Type | |||||
object string | |||||
object string Type | |||||
SQLite.SQLiteAsyncConnection.InsertOrReplaceAsync |
object | ||||
object Type | |||||
SQLite.SQLiteAsyncConnection.InsertAllAsync |
IEnumerable bool | ||||
IEnumerable string bool | |||||
IEnumerable Type bool | |||||
SQLite.SQLiteAsyncConnection.UpdateAsync |
object | ||||
object Type | |||||
SQLite.SQLiteAsyncConnection.UpdateAllAsync | IEnumerable bool | ||||
SQLite.SQLiteAsyncConnection.DeleteAsync | object | ||||
SQLite.SQLiteAsyncConnection.DeleteAllAsync | |||||
SQLite.SQLiteAsyncConnection.GetAsync |
object | ||||
object TableMapping | |||||
SQLite.SQLiteAsyncConnection.FindAsync |
object | ||||
object TableMapping | |||||
SQLite.SQLiteAsyncConnection.FindWithQueryAsync |
string params object[] | ||||
TableMapping string params object[] | |||||
SQLite.SQLiteAsyncConnection.GetTableInfoAsync | string | ||||
SQLite.SQLiteAsyncConnection.ExecuteAsync | string params object[] | ||||
| SQLite.SQLiteAsyncConnection.ExecuteScalarAsync | string params object[] | ||||
SQLite.SQLiteAsyncConnection.QueryAsync | string params object[] | ||||
SQLite.SQLiteAsyncConnection.QueryScalarsAsync | string params object[] | ||||
SQLite.SQLiteAsyncConnection.DeferredQueryAsync | string params object[] |
SAP ASE
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| SAP ASE | Sybase.Data.AseClient (.NET Data Provider for Sybase ASE) |
Sybase.Data.AseClient.AseCommand.ExecuteReader | Sybase.Data.AseClient.AseCommand.CommandText | ||
Sybase.Data.AseClient.AseCommand.BeginExecuteReader | |||||
Sybase.Data.AseClient.AseCommand.ExecuteNonQuery | |||||
Sybase.Data.AseClient.AseCommand.BeginExecuteNonQuery | |||||
Sybase.Data.AseClient.AseCommand.ExecuteScalar | |||||
Sybase.Data.AseClient.AseCommand.ExecuteXmlReader | |||||
Sybase.Data.AseClient.AseCommand.BeginExecuteXmlReader | |||||
Sybase.Data.AseClient.AseDataAdapter.Fill | Sybase.Data.AseClient.AseDataAdapter.SelectCommand | ||||
Sybase.Data.AseClient.AseDataAdapter.FillSchema | |||||
Sybase.Data.AseClient.AseDataAdapter.Update | Sybase.Data.AseClient.AseDataAdapter.InsertCommand Sybase.Data.AseClient.AseDataAdapter.UpdateCommand Sybase.Data.AseClient.AseDataAdapter.DeleteCommand | ||||
AdoNetCore.AseClient (.NET Core Data Provider for Sybase ASE) |
AdoNetCore.AseClient.AseCommand.ExecuteReader | AdoNetCore.AseClient.AseCommand.CommandText | |||
AdoNetCore.AseClient.AseCommand.ExecuteNonQuery | |||||
AdoNetCore.AseClient.AseCommand.ExecuteScalar | |||||
AdoNetCore.AseClient.AseCommand.ExecuteXmlReader | |||||
AdoNetCore.AseClient.AseDataAdapter.Fill | AdoNetCore.AseClient.AseDataAdapter.SelectCommand | ||||
AdoNetCore.AseClient.AseDataAdapter.FillSchema | |||||
AdoNetCore.AseClient.AseDataAdapter.Update | AdoNetCore.AseClient.AseDataAdapter.InsertCommand AdoNetCore.AseClient.AseDataAdapter.UpdateCommand AdoNetCore.AseClient.AseDataAdapter.DeleteCommand |
Teradata
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| Teradata | Teradata.Client.Provider (.NET Data Provider for Teradata) |
Teradata.Client.Provider.TdCommand.ExecuteReader | Teradata.Client.Provider.TdCommand.CommandText | ||
Teradata.Client.Provider.TdCommand.ExecuteReaderAsync | |||||
Teradata.Client.Provider.TdCommand.BeginExecuteReader | |||||
Teradata.Client.Provider.TdCommand.ExecuteNonQuery | |||||
Teradata.Client.Provider.TdCommand.ExecuteNonQueryAsync | |||||
Teradata.Client.Provider.TdCommand.BeginExecuteNonQuery | |||||
Teradata.Client.Provider.TdCommand.ExecuteScalar | |||||
Teradata.Client.Provider.TdCommand.ExecuteScalarAsync | |||||
Teradata.Client.Provider.TdCommand.ExecuteCreateProcedure | |||||
Teradata.Client.Provider.TdDataAdapter.Fill | Teradata.Client.Provider.TdDataAdapter.SelectCommand | ||||
Teradata.Client.Provider.TdDataAdapter.FillSchema | |||||
Teradata.Client.Provider.TdDataAdapter.Update | Teradata.Client.Provider.TdDataAdapter.InsertCommand Teradata.Client.Provider.TdDataAdapter.UpdateCommand Teradata.Client.Provider.TdDataAdapter.DeleteCommand |
SnowFlake
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| SnowFlake | Snowflake.Client (.NET Client for Snowflake DB REST API) |
Snowflake.Client.SnowflakeClient.ExecuteAsync | |||
Snowflake.Client.SnowflakeClient.ExecuteScalarAsync | |||||
Snowflake.Client.SnowflakeClient.QueryAsync | |||||
Snowflake.Client.SnowflakeClient.QueryRawResponseAsync | |||||
Snowflake.Data.Client (Snowflake Connector for .NET) |
Snowflake.Data.Client.SnowflakeDbCommand.ExecuteNonQuery | Snowflake.Data.Client.SnowflakeDbCommand.CommandText | |||
Snowflake.Data.Client.SnowflakeDbCommand.ExecuteNonQueryAsync | |||||
Snowflake.Data.Client.SnowflakeDbCommand.ExecuteScalar | |||||
Snowflake.Data.Client.SnowflakeDbCommand.ExecuteScalarAsync |
Spring
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| Spring | Spring.Data.Generic (Spring Data Generic ADO.NET Provider) |
Spring.Data.Generic.AdoTemplate.Execute |
IDataAdapterCallback | DoInDataAdapter(IDbDataAdapter) | |
| IDbCommandCreator | CreateDbCommand(IDbProvider) | ||||
| IDbCommandDelegate | |||||
| IDbCommandCallback | DoInCommand(IDbCommand) | ||||
| CommandDelegate | |||||
| ICommandCallback | DoInCommand(DbCommand) | ||||
| DataAdapterDelegate | |||||
Spring.Data.Generic.AdoTemplate.ExecuteNonQuery |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
| IDbCommandCreator | CreateDbCommand(IDbProvider) | ||||
Spring.Data.Generic.AdoTemplate.ExecuteScalar |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
| IDbCommandCreator | CreateDbCommand(IDbProvider) | ||||
Spring.Data.Generic.AdoTemplate.QueryForObject |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
Spring.Data.Generic.AdoTemplate.QueryForObjectDelegate |
string | ||||
| ICommandSetter | SetValues(IDbCommand) | ||||
Spring.Data.Generic.AdoTemplate.QueryWithCommandCreator | IDbCommandCreator | CreateDbCommand(IDbProvider) | |||
Spring.Data.Generic.AdoTemplate.QueryWithResultSetExtractor |
string ICommandSetter | SetValues(IDbCommand) | |||
string CommandSetterDelegate | |||||
| string | |||||
Spring.Data.Generic.AdoTemplate.QueryWithResultSetExtractorDelegate |
string ICommandSetter | SetValues(IDbCommand) | |||
string CommandSetterDelegate | |||||
| string | |||||
Spring.Data.Generic.AdoTemplate.QueryWithRowCallback |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
Spring.Data.Generic.AdoTemplate.QueryWithRowCallbackDelegate |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
Spring.Data.Generic.AdoTemplate.QueryWithRowMapper |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
Spring.Data.Generic.AdoTemplate.QueryWithRowMapperDelegate |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
Spring.Data.Core (Spring Data Core ADO.NET Provider) |
Spring.Data.Core.AdoTemplate.DataSetCreate |
string | |||
string IDataAdapterSetter | SetValues(IDbDataAdapter) | ||||
Spring.Data.Core.AdoTemplate.DataSetCreateWithParams |
string | ||||
string IDataAdapterSetter | SetValues(IDbDataAdapter) | ||||
Spring.Data.Core.AdoTemplate.DataSetFill |
string | ||||
string IDataAdapterSetter | SetValues(IDbDataAdapter) | ||||
Spring.Data.Core.AdoTemplate.DataSetFillWithParameters |
string | ||||
string IDataAdapterSetter | SetValues(IDbDataAdapter) | ||||
Spring.Data.Core.AdoTemplate.DataSetUpdate |
IDbCommand IDbCommand IDbCommand | CreateDbCommand(IDbProvider) - - | |||
string string string | |||||
IDbCommand IDbCommand IDbCommand IDataAdapterSetter | CreateDbCommand(IDbProvider) - - SetValues(IDbDataAdapter) | ||||
Spring.Data.Core.AdoTemplate.DataSetUpdateWithCommandBuilder |
string | ||||
string IDataAdapterSetter | SetValues(IDbDataAdapter) | ||||
Spring.Data.Core.AdoTemplate.DataTableCreate |
string | ||||
string IDataAdapterSetter | SetValues(IDbDataAdapter) | ||||
Spring.Data.Core.AdoTemplate.DataTableCreateWithParams |
string | ||||
string IDataAdapterSetter | SetValues(IDbDataAdapter) | ||||
Spring.Data.Core.AdoTemplate.DataTableFill |
string | ||||
string IDataAdapterSetter | SetValues(IDbDataAdapter) | ||||
Spring.Data.Core.AdoTemplate.DataTableFillWithParams |
string | ||||
string IDataAdapterSetter | SetValues(IDbDataAdapter) | ||||
Spring.Data.Core.AdoTemplate.DataTableUpdate |
string string string IDataAdapterSetter | SetValues(IDbDataAdapter) | |||
string string string | |||||
Spring.Data.Core.AdoTemplate.DataTableUpdateWithCommandBuilder |
string | ||||
string IDataAdapterSetter | SetValues(IDbDataAdapter) | ||||
Spring.Data.Core.AdoTemplate.Execute |
IDataAdapterCallback | DoInDataAdapter(IDbDataAdapter) | |||
| IDbCommandCreator | CreateDbCommand(IDbProvider) | ||||
| IDbCommandDelegate | |||||
| IDbCommandCallback | DoInCommand(IDbCommand) | ||||
| CommandDelegate | |||||
| ICommandCallback | DoInCommand(DbCommand) | ||||
| DataAdapterDelegate | |||||
Spring.Data.Core.AdoTemplate.ExecuteNonQuery |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
| IDbCommandCreator | CreateDbCommand(IDbProvider) | ||||
Spring.Data.Core.AdoTemplate.ExecuteScalar |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
| IDbCommandCreator | CreateDbCommand(IDbProvider) | ||||
Spring.Data.Core.AdoTemplate.QueryForObject |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
Spring.Data.Core.AdoTemplate.QueryForObjectDelegate |
string | ||||
| ICommandSetter | SetValues(IDbCommand) | ||||
Spring.Data.Core.AdoTemplate.QueryWithCommandCreator | IDbCommandCreator | CreateDbCommand(IDbProvider) | |||
Spring.Data.Core.AdoTemplate.QueryWithResultSetExtractor |
string ICommandSetter | SetValues(IDbCommand) | |||
string CommandSetterDelegate | |||||
| string | |||||
Spring.Data.Core.AdoTemplate.QueryWithResultSetExtractorDelegate |
string ICommandSetter | SetValues(IDbCommand) | |||
string CommandSetterDelegate | |||||
| string | |||||
Spring.Data.Core.AdoTemplate.QueryWithRowCallback |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
Spring.Data.Core.AdoTemplate.QueryWithRowCallbackDelegate |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
Spring.Data.Core.AdoTemplate.QueryWithRowMapper |
string | ||||
string ICommandSetter | SetValues(IDbCommand) | ||||
Spring.Data.Core.AdoTemplate.QueryWithRowMapperDelegate |
string | ||||
string ICommandSetter | SetValues(IDbCommand) |
LinqToDB
| Vendor | Namespace | Method | Parameter | Attribute | Value | |
|---|---|---|---|---|---|---|
| LinqToDB | LinqToDB.Mapping |
LinqToDB.Mapping.EntityMappingBuilder.HasTableName |
string | LinqToDB.Mapping.FluentMappingBuilder.Entity | LinqToDB.Mapping.TableAttribute | |
LinqToDB.DataExtensions |
LinqToDB.DataExtensions.CreateTable |
string | LinqToDB.DataExtensions.GetTable LinqToDB.Data.DataConnection.GetTable |
|||
LinqToDB.DataExtensions.CreateTableAsync |
string | |||||
LinqToDB.DataExtensions.DropTable |
string | |||||
LinqToDB.DataExtensions.DropTableAsync |
string | |||||
LinqToDB.DataExtensions.Insert |
T | |||||
LinqToDB.DataExtensions.InsertAsync |
T | |||||
LinqToDB.DataExtensions.InsertOrReplace |
T | |||||
LinqToDB.DataExtensions.InsertOrReplaceAsync |
T | |||||
LinqToDB.DataExtensions.InsertWithIdentity |
T | |||||
LinqToDB.DataExtensions.InsertWithInt32Identity |
T | |||||
LinqToDB.DataExtensions.InsertWithInt64Identity | T | |||||
LinqToDB.DataExtensions.InsertWithDecimalIdentity | T | |||||
LinqToDB.DataExtensions.Update | T | |||||
LinqToDB.DataExtensions.UpdateAsync | T | |||||
LinqToDB.DataExtensions.Delete | T | |||||
LinqToDB.DataExtensions.DeleteAsync | T | |||||
LinqToDB.AsyncExtensions |
LinqToDB.AsyncExtensions.AllAsync | |||||
LinqToDB.AsyncExtensions.AnyAsync | ||||||
LinqToDB.AsyncExtensions.AverageAsync | ||||||
LinqToDB.AsyncExtensions.FirstAsync | ||||||
LinqToDB.AsyncExtensions.FirstOrDefaultAsync | ||||||
LinqToDB.AsyncExtensions.SingleAsync | ||||||
LinqToDB.AsyncExtensions.SingleOrDefaultAsync | ||||||
LinqToDB.AsyncExtensions.ContainsAsync | ||||||
LinqToDB.AsyncExtensions.CountAsync | ||||||
LinqToDB.AsyncExtensions.LongCountAsync | ||||||
LinqToDB.AsyncExtensions.MinAsync | ||||||
LinqToDB.AsyncExtensions.MaxAsync | ||||||
LinqToDB.AsyncExtensions.SumAsync | ||||||
LinqToDB.AsyncExtensions.ToListAsync | ||||||
LinqToDB.AsyncExtensions.ToArrayAsync | ||||||
LinqToDB.AsyncExtensions.ToDictionaryAsync | ||||||
LinqToDB.AsyncExtensions.ForEachAsync | ||||||
LinqToDB.AsyncExtensions.ForEachUntilAsync | ||||||
LinqToDB.LinqExtensions |
LinqToDB.LinqExtensions.Update |
T |
LinqToDB.LinqExtensions.LoadWith LinqToDB.LinqExtensions.Join LinqToDB.LinqExtensions.LeftJoin LinqToDB.LinqExtensions.InnerJoin LinqToDB.LinqExtensions.RightJoin LinqToDB.LinqExtensions.FullJoin LinqToDB.LinqExtensions.CrossJoin |
|||
LinqToDB.LinqExtensions.UpdateAsync |
T | |||||
LinqToDB.LinqExtensions.Delete | T | |||||
LinqToDB.LinqExtensions.DeleteAsync | T | |||||
LinqToDB.LinqExtensions.Insert | T | |||||
LinqToDB.LinqExtensions.InsertAsync | T | |||||
LinqToDB.LinqExtensions.InsertWithIdentity | T | |||||
LinqToDB.LinqExtensions.InsertWithInt32Identity | T | |||||
LinqToDB.LinqExtensions.InsertWithInt64Identity | T | |||||
LinqToDB.LinqExtensions.InsertWithDecimalIdentity | T | |||||
LinqToDB.LinqExtensions.InsertWithIdentityAsync | T | |||||
LinqToDB.LinqExtensions.InsertWithInt32IdentityAsync | T | |||||
LinqToDB.LinqExtensions.InsertWithDecimalIdentityAsync | T | |||||
LinqToDB.LinqExtensions.InsertOrUpdate | T | |||||
LinqToDB.LinqExtensions.InsertOrUpdateAsync | T | |||||
LinqToDB.LinqExtensions.Drop | T | |||||
LinqToDB.LinqExtensions.DropAsync | T | |||||
LinqToDB.LinqExtensions.Truncate | T | |||||
LinqToDB.LinqExtensions.TruncateAsync | T |
ServiceStack
| Vendor | Namespace | Method | Parameter | Attribute | Value |
|---|---|---|---|---|---|
| ServiceStack | ServiceStack.DataAnnotations |
ServiceStack.DataAnnotations.AliasAttribute |
|||
ServiceStack.OrmLite |
ServiceStack.OrmLite.OrmLiteSchemaApi.CreateTable |
<T> |
ServiceStack.OrmLite.SqlExpression<T>.Join<Target> ServiceStack.OrmLite.SqlExpression<T>.CustomJoin<Target> |
||
bool |
|||||
ServiceStack.OrmLite.OrmLiteSchemaApi.CreateTables |
bool |
||||
ServiceStack.OrmLite.OrmLiteSchemaApi.CreateTableIfNotExists |
params Type[] |
||||
ServiceStack.OrmLite.OrmLiteSchemaApi.DropAndCreateTable |
<T> |
||||
ServiceStack.OrmLite.OrmLiteSchemaApi.DropAndCreateTables |
Type |
||||
ServiceStack.OrmLite.OrmLiteSchemaApi.DropTable |
<T> |
||||
Type |
|||||
ServiceStack.OrmLite.OrmLiteSchemaApi.DropTables |
params Type[] |
||||
ServiceStack.OrmLite.OrmLiteReadApi.Select |
<T> |
||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.SelectFmt |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.SelectByIds |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.SelectNonDefaults |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.SelectLazy |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.SelectLazyFmt |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.Where |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.WhereLazy |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.Single |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.SingleFmt |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.SingleById |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.SingleWhere |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.Scalar |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.ScalarFmt |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.Column |
<T> |
||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.ColumnFmt |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.ColumnLazy |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.ColumnDistinct |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.ColumnDistinctFmt |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadApi.Lookup |
<K, V> |
||||
<K, V> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.Dictionary |
<K, V> |
||||
<K, V> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.KeyValuePairs |
<K, V> |
||||
<K, V> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.Exists |
<T> |
||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.SqlList |
<T> |
||||
<T> |
|||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.SqlColumn |
<T> |
||||
<T> |
|||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.SqlScalar |
<T> |
||||
<T> |
|||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.LoadSingleById |
<T> |
||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadApi.LoadReferences |
<T> |
||||
ServiceStack.OrmLite.OrmLiteReadExpressionsApi.Select |
<T> |
||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadExpressionsApi.SelectMulti |
<T, T2, ... T8> |
||||
<T, T2, ... T8> |
|||||
ServiceStack.OrmLite.OrmLiteReadExpressionsApi.Single |
<T> |
||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadExpressionsApi.Scalar |
<T, TKey> |
||||
<T, TKey> |
|||||
ServiceStack.OrmLite.OrmLiteReadExpressionsApi.Count |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadExpressionsApi.RowCount |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteReadExpressionsApi.LoadSelect |
<T> |
||||
<T> |
|||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.ExecuteSql |
string |
||||
string |
|||||
string |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.Insert |
<T> |
||||
<T> |
|||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.InsertUsingDefaults |
<T> |
||||
ServiceStack.OrmLite.OrmLiteWriteApi.InsertIntoSelect |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.InsertAll |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.BulkInsert |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.Update |
<T> |
||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.UpdateAll |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.Delete |
<T> |
||||
<T> |
|||||
<T> |
|||||
<T> |
|||||
string |
|||||
Type |
|||||
Type |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.DeleteAll |
<T> |
||||
Type |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.DeleteNonDefaults |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.DeleteById |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.DeleteByIds |
<T> |
||||
ServiceStack.OrmLite.OrmLiteWriteApi.Save |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.SaveAll |
<T> |
||||
ServiceStack.OrmLite.OrmLiteWriteApi.SaveReferences |
<T, TRef> |
||||
<T, TRef> |
|||||
<T, TRef> |
|||||
ServiceStack.OrmLite.OrmLiteWriteApi.ExecuteProcedure |
<T> |
||||
ServiceStack.OrmLite.OrmLiteWriteExpressionsApi.Update |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteExpressionsApi.UpdateAdd |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteExpressionsApi.UpdateOnly |
<T> |
||||
<T> |
|||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteExpressionsApi.UpdateOnlyFields |
<T> |
||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteExpressionsApi.UpdateNonDefaults |
<T> |
||||
ServiceStack.OrmLite.OrmLiteWriteExpressionsApi.InsertOnly |
<T> |
||||
<T> |
|||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteExpressionsApi.Delete |
<T> |
||||
<T> |
|||||
ServiceStack.OrmLite.OrmLiteWriteExpressionsApi.DeleteWhere |
<T> |
What results can you expect?
Objects
The following objects are created by the extension:
| Icon | Object type Description | When is this object created ? |
|---|---|---|
 |
Dotnet Ado Query | An object is created for each SQL query found and resolved in an Dotnet CRUD method call |
 |
DotNet Unknown ADO Query | An object is created for each SQL query found but could not be resolved correctly in an Dotnet CRUD method call, only one is created per real caller |
 |
DotNet ADO Entity | An object is created for each entity found and resolved in an Dotnet CRUD method call |
 |
DotNet ADO Entity Operation | An object is created for each entity operation found and resolved in an Dotnet CRUD method call |
Links
The following links will be created by the Ado.Net extension, or by alternate extensions.
| Link type | Real caller type | Callee type | Additional information |
|---|---|---|---|
| callLink | C# Method | |
Created by this analyser - Dotnet Ado |
| callLink | C# Method | |
Created by this analyser - Dotnet Ado |
| callLink | C# Method | |
Created by this analyser - Dotnet Ado |
| callLink | C# Method | |
Created by this analyser - Dotnet Ado |
| relyonLink | |
|
Created by this analyser - Dotnet Ado |
| useLink | |
 |
Created by Sql analyser |
| useLink | |
|
Created by Sql analyser |
| callLink | |
 |
Created by Sql analyser |
| useLink | |
 |
Created by Missing tables and procedures for .NET when the object is not analyzed |
| callLink | |
 |
Created by Missing tables and procedures for .NET when the object is not analyzed |
Git samples
Direct SQL
DirectSQL-main\TestSqlLiteDatabase\SqlResultTest.cs
private static void CreateTableForTest(IDbConnection connection)
{
using (var command = connection.CreateCommand())
{
command.CommandText =
"create table " +
"TEST_TABLE(" +
"TEST_COL1 text," +
"TEST_COL2 integer" +
")";
command.ExecuteNonQuery();
}
}
One Ado object is created:
DirectSQL-main\TestSqlLiteDatabase\QueryDefaultTransaction.cs
private static void CreateTableForTest(IDbConnection connection)
{
using( var command = connection.CreateCommand())
{
command.CommandText =
"create table " +
"TEST_TABLE(" +
"TEST_VAL1 text," +
"TEST_VAL2 integer" +
")";
command.ExecuteNonQuery();
}
}
One Ado object is created:
Employee management
ASPNetCore_ADO-master\EmployeeManagement\Models\EmployeeDataAccessLayer.cs
public Employee GetEmployeeData(int? id)
{
Employee employee = new Employee();
using (SqlConnection con = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM tblEmployee WHERE EmployeeID= " + id;
SqlCommand cmd = new SqlCommand(sqlQuery, con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
employee.ID = Convert.ToInt32(rdr["EmployeeID"]);
employee.Name = rdr["Name"].ToString();
employee.Gender = rdr["Gender"].ToString();
employee.Department = rdr["Department"].ToString();
employee.City = rdr["City"].ToString();
}
}
return employee;
}
One Ado object is created:
Test case
using System.Data.Linq;
using System.Data.Linq.Mapping;
namespace Test01_linq_sql
{
[Table(Name = "CustomerInfo")]
public class CustomerData
{
[Column(IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.OnInsert)]
public int CustomerId { get; set; }
[Column]
public string CustomerName { get; set; } = default!;
[Column]
public string FirstName { get; set; } = default!;
[Column]
public string Contact { get; set; } = default!;
[Column]
public string Address { get; set; } = default!;
[Column]
public string City { get; set; } = default!;
[Column]
public string PostalCode { get; set; } = default!;
[Column]
public string Country { get; set; } = default!;
}
public class Program
{
static void Main(string[] args)
{
string connectionStr = "Data Source=.;database=AdoNet;Integrated Security=SSPI;";
DataContext AdoNetDb = new DataContext(connectionStr);
Table<CustomerData> CustomerTable = AdoNetDb.GetTable<CustomerData>();
// display values after reading
foreach(var line in CustomerTable)
{
Console.WriteLine(line.CustomerName);
}
// Create a new Order object
CustomerTable.InsertOnSubmit(
new CustomerData
{
CustomerName = "Can1",
FirstName = "Furrya",
Contact = "trans_tarzan_of_the_jungle@gmail.com",
Address = "Amazonia",
City = "NoWhere",
PostalCode = "XXXXXX",
Country = "Brazil"
}
);
CustomerData ord = new CustomerData
{
// CustomerId = 6,
CustomerName = "De La Crème",
FirstName = "Thierry",
Contact = "itsmaam@gmail.com",
Address = "Down town LA",
City = "California",
PostalCode = "XXXXXX",
Country = "Murika"
};
CustomerTable.InsertOnSubmit(ord);
AdoNetDb.SubmitChanges();
IEnumerable<CustomerData> productQuery =
from prod in CustomerTable
where prod.CustomerId == 3
select prod;
foreach(var i in productQuery)
{
Console.WriteLine(i.CustomerName);
}
CustomerTable.DeleteOnSubmit(ord);
AdoNetDb.SubmitChanges();
IEnumerable<CustomerData> productQuery2 =
from prod in CustomerTable
select prod;
foreach(var i in productQuery2)
{
Console.WriteLine(i.CustomerName);
}
}
}
}
4 Ado objects are created:
Limitations
- In case of dotnet ado query object, each evaluation that results in standard exception or empty value will lead to one unknown object creation. Also, failure in value conversion will create unknown object.
- As of now, there isn’t any creation for either unknown entity or its operation. If a vital information is missing, the extension will jump to the next evaluation to begin a new process.
- Some query objects need better fitlering to determine if their values should be considered unknown.
- Support for Linq To Dataset is not covered in this release.