This documentation is not maintained. Please refer to doc.castsoftware.com/technologies to find the latest updates.

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.

VendorNamespaceMethodParameterAttributeValue
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

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




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.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


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.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.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.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

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

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

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

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



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.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



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[] 



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.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

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

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)

IDbCommandCreatorCreateDbCommand(IDbProvider)

Spring.Data.Generic.AdoTemplate.ExecuteScalar

string



string

ICommandSetter


SetValues(IDbCommand)

IDbCommandCreatorCreateDbCommand(IDbProvider)

Spring.Data.Generic.AdoTemplate.QueryForObject

string




string

ICommandSetter


SetValues(IDbCommand)

Spring.Data.Generic.AdoTemplate.QueryForObjectDelegate

string


ICommandSetterSetValues(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)


IDbCommandCreatorCreateDbCommand(IDbProvider)

Spring.Data.Core.AdoTemplate.ExecuteScalar

string

string

ICommandSetter


SetValues(IDbCommand)


IDbCommandCreatorCreateDbCommand(IDbProvider)

Spring.Data.Core.AdoTemplate.QueryForObject

string



string

ICommandSetter


SetValues(IDbCommand)


Spring.Data.Core.AdoTemplate.QueryForObjectDelegate

string

ICommandSetterSetValues(IDbCommand)

Spring.Data.Core.AdoTemplate.QueryWithCommandCreator

IDbCommandCreatorCreateDbCommand(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)


AIP Core compatibility

This extension is compatible with:

AIP Core releaseSupported
 ≥ 8.3.5(tick)

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:

IconObject type DescriptionWhen is this object created ?

Dotnet Ado Queryan object is created for each SQL query found and resolved in an ADO.Net CRUD method call 

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

Link typeCaller typeCallee type

Methods Supported

callLink

CAST_DotNet_GenericMethodCSharp.PNG 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.