Extension ID

com.castsoftware.dotnet.ado

What's new?

See ADO.NET - 1.0 - Release Notes for more information.

Description

This extension provides support for SQL query execution calls under ADO.NET using C# language.

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.

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.SelectCommand
		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.SelectCommand
		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.SelectCommand
		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	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.SqlBulkCopy.DestinationTableName
		Microsoft.Data.SqlClient.SqlDataAdapter.Fill		Microsoft.Data.SqlClient.SqlDataAdapter.SelectCommand
		Microsoft.Data.SqlClient.SqlDataAdapter.FillSchema		Microsoft.Data.SqlClient.SqlDataAdapter.SelectCommand
		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.SqlBulkCopy.DestinationTableName
		System.Data.SqlClient.SqlDataAdapter.Fill		System.Data.SqlClient.SqlDataAdapter.SelectCommand
		System.Data.SqlClient.SqlDataAdapter.FillSchema		System.Data.SqlClient.SqlDataAdapter.SelectCommand
		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.SelectCommand
		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.SelectCommand
		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
		System.Data.OleDb.OleDbCommand.ExecuteReaderAsync			CommandType.Text CommandType.TableDirect CommandType.StoredProcedure
		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.SelectCommand
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.SelectCommand
	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
	System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery			CommandType.Text CommandType.TableDirect CommandType.StoredProcedure
	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.SelectCommand
	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 (.NET Data Provider for LINQ to SQL)	System.Data.Linq.DataContext.ExecuteQuery
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.SelectCommand
		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.MySqlBulkCopy.DestinationTableName
		MySqlConnector.MySqlBulkLoader.Load		MySqlConnector.MySqlBulkLoader.TableName
		MySqlConnector.MySqlBulkLoader.LoadAsync		MySqlConnector.MySqlBulkLoader.TableName
		MySqlConnector.MySqlDataAdapter.Fill		MySqlConnector.MySqlDataAdapter.SelectCommand
		MySqlConnector.MySqlDataAdapter.FillSchema		MySqlConnector.MySqlDataAdapter.SelectCommand
		MySqlConnector.MySqlDataAdapter.Update		MySqlConnector.MySqlDataAdapter.InsertCommand MySqlConnector.MySqlDataAdapter.UpdateCommand MySqlConnector.MySqlDataAdapter.DeleteCommand
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.SelectCommand
		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	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.SqlStatement.Text
		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		Devart.Data.SQLite.SQLiteCommand.CommandText
		(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		Devart.Data.PostgreSql.PgSqlCommand.CommandText
		(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 (Devart’s dotConnect for LINQ to SQL)	Devart.Data.Linq.DataContext.ExecuteQuery
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.SelectCommand
		Npgsql.NpgsqlDataAdapter.Update		Npgsql.NpgsqlDataAdapter.InsertCommand Npgsql.NpgsqlDataAdapter.UpdateCommand Npgsql.NpgsqlDataAdapter.DeleteCommand
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.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
		SQLite.SQLiteConnection.Get	object TableMapping
		SQLite.SQLiteConnection.Find	object
		SQLite.SQLiteConnection.Find	object TableMapping
		SQLite.SQLiteConnection.FindWithQuery	string params object[]
		SQLite.SQLiteConnection.FindWithQuery	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
		SQLite.SQLiteConnection.InsertOrReplace	object Type
		SQLite.SQLiteConnection.Update	object
		SQLite.SQLiteConnection.Update	object Type
		SQLite.SQLiteConnection.UpdateAll	IEnumerable bool
		SQLite.SQLiteConnection.Delete	object
		SQLite.SQLiteConnection.DeleteAll
		SQLite.SQLiteConnection.Table
		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
		SQLite.SQLiteAsyncConnection.InsertOrReplaceAsync	object Type
		SQLite.SQLiteAsyncConnection.InsertAllAsync	IEnumerable bool
			IEnumerable string bool
			IEnumerable Type bool
		SQLite.SQLiteAsyncConnection.UpdateAsync	object
		SQLite.SQLiteAsyncConnection.UpdateAsync	object Type
		SQLite.SQLiteAsyncConnection.UpdateAllAsync	IEnumerable bool
		SQLite.SQLiteAsyncConnection.DeleteAsync	object
		SQLite.SQLiteAsyncConnection.DeleteAllAsync
		SQLite.SQLiteAsyncConnection.GetAsync	object
		SQLite.SQLiteAsyncConnection.GetAsync	object TableMapping
		SQLite.SQLiteAsyncConnection.FindAsync	object
		SQLite.SQLiteAsyncConnection.FindAsync	object TableMapping
		SQLite.SQLiteAsyncConnection.FindWithQueryAsync	string params object[]
		SQLite.SQLiteAsyncConnection.FindWithQueryAsync	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[]
SQLite.SQLiteAsyncConnection.Table
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.SelectCommand
		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.SelectCommand
		AdoNetCore.AseClient.AseDataAdapter.Update		AdoNetCore.AseClient.AseDataAdapter.InsertCommand AdoNetCore.AseClient.AseDataAdapter.UpdateCommand AdoNetCore.AseClient.AseDataAdapter.DeleteCommand
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.SelectCommand
		Teradata.Client.Provider.TdDataAdapter.Update		Teradata.Client.Provider.TdDataAdapter.InsertCommand Teradata.Client.Provider.TdDataAdapter.UpdateCommand Teradata.Client.Provider.TdDataAdapter.DeleteCommand
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	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
		Spring.Data.Generic.AdoTemplate.QueryForObject	string ICommandSetter	SetValues(IDbCommand)
		Spring.Data.Generic.AdoTemplate.QueryForObjectDelegate	string
		Spring.Data.Generic.AdoTemplate.QueryForObjectDelegate	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
		Spring.Data.Generic.AdoTemplate.QueryWithRowCallback	string ICommandSetter	SetValues(IDbCommand)
		Spring.Data.Generic.AdoTemplate.QueryWithRowCallbackDelegate	string
			string ICommandSetter	SetValues(IDbCommand)
		Spring.Data.Generic.AdoTemplate.QueryWithRowMapper	string
		Spring.Data.Generic.AdoTemplate.QueryWithRowMapper	string ICommandSetter	SetValues(IDbCommand)
		Spring.Data.Generic.AdoTemplate.QueryWithRowMapperDelegate	string
		Spring.Data.Generic.AdoTemplate.QueryWithRowMapperDelegate	string ICommandSetter	SetValues(IDbCommand)
	Spring.Data.Core (Spring Data Core ADO.NET Provider)	Spring.Data.Core.AdoTemplate.DataSetCreate	string
		Spring.Data.Core.AdoTemplate.DataSetCreate	string IDataAdapterSetter	SetValues(IDbDataAdapter)
		Spring.Data.Core.AdoTemplate.DataSetCreateWithParams	string
		Spring.Data.Core.AdoTemplate.DataSetCreateWithParams	string IDataAdapterSetter	SetValues(IDbDataAdapter)
		Spring.Data.Core.AdoTemplate.DataSetFill	string
		Spring.Data.Core.AdoTemplate.DataSetFill	string IDataAdapterSetter	SetValues(IDbDataAdapter)
		Spring.Data.Core.AdoTemplate.DataSetFillWithParameters	string
		Spring.Data.Core.AdoTemplate.DataSetFillWithParameters	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
		Spring.Data.Core.AdoTemplate.DataTableCreate	string IDataAdapterSetter	SetValues(IDbDataAdapter)
		Spring.Data.Core.AdoTemplate.DataTableCreateWithParams	string
		Spring.Data.Core.AdoTemplate.DataTableCreateWithParams	string IDataAdapterSetter	SetValues(IDbDataAdapter)
		Spring.Data.Core.AdoTemplate.DataTableFill	string
		Spring.Data.Core.AdoTemplate.DataTableFill	string IDataAdapterSetter	SetValues(IDbDataAdapter)
		Spring.Data.Core.AdoTemplate.DataTableFillWithParams	string
		Spring.Data.Core.AdoTemplate.DataTableFillWithParams	string IDataAdapterSetter	SetValues(IDbDataAdapter)
		Spring.Data.Core.AdoTemplate.DataTableUpdate	string string string IDataAdapterSetter	SetValues(IDbDataAdapter)
		Spring.Data.Core.AdoTemplate.DataTableUpdate	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
Spring.Data.Core.AdoTemplate.QueryForObject		string ICommandSetter	SetValues(IDbCommand)
Spring.Data.Core.AdoTemplate.QueryForObjectDelegate		string
Spring.Data.Core.AdoTemplate.QueryForObjectDelegate		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
Spring.Data.Core.AdoTemplate.QueryWithRowCallback		string ICommandSetter	SetValues(IDbCommand)
Spring.Data.Core.AdoTemplate.QueryWithRowCallbackDelegate		string
Spring.Data.Core.AdoTemplate.QueryWithRowCallbackDelegate		string ICommandSetter	SetValues(IDbCommand)
Spring.Data.Core.AdoTemplate.QueryWithRowMapper		string
Spring.Data.Core.AdoTemplate.QueryWithRowMapper		string ICommandSetter	SetValues(IDbCommand)
Spring.Data.Core.AdoTemplate.QueryWithRowMapperDelegate		string
Spring.Data.Core.AdoTemplate.QueryWithRowMapperDelegate		string ICommandSetter	SetValues(IDbCommand)

AIP Core compatibility

This extension is compatible with:

AIP Core release	Supported
≥ 8.3.5

Download and installation instructions

For C# applications using ADO.Net, the extension will be automatically installed by CAST Console. This is in place since October 2023.

For upgrade, if the Extension Strategy is not set to Auto update, you can manually install the extension using the Application - Extensions interface.

What results can you expect?

Objects

The following objects are created by the extension, with the corresponding icon displayed in CAST Enlighten:

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 ADO.Net CRUD method call

Links

The following links will be created by the Ado.Net extension, or by alternate extensions.

Link type	Caller type	Callee type	Methods Supported
callLink	C# Method	Dotnet Ado Query	All CRUD methods supported from all supported ADO.NET providers (see above)
useLink	Dotnet Ado Query	Table / View	Created by SQL Analyzer when DDL source files are analyzed
callLink	Dotnet Ado Query	Procedure
useLink	Dotnet Ado Query	Missing Table	Created by Missing tables and procedures for .Net extension when the object is not analyzed
callLink	Dotnet Ado Query	Missing Procedure

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:

Limitations

Traceback in evaluating string with common exception AttributeError, TypeError, etc.
Generic parameter needs better support in string evaluation to find resolution for object like class, method, etc.
List and other collection entities also need better support in string evaluation in order to return full values for a complete SQL query construction.