IBConnection

Identità

• Namespace: B.BInterfaces

• Assembly: BFramework

• Tipo: interface

• Sorgente API: versione 5.0.0

Scopo

Definisce il contratto pubblico IBConnection del namespace B.BInterfaces.

Dichiarazione

public interface IBConnection

Proprietà

Metodi

• bool AddParameter(IDbDataParameter Param)

• void AddParameter(IDbDataParameter[] Params)

• bool AddParameter(string ParamName, object? ParamValue)

• void ApriDatabase()

• DataSet ApriDS(string SPName, int CommandTimeout = 30)

• DataSet ApriDS(string SPName, IDbDataParameter[] Params)

• DataTable ApriDT(string SqlCommand, IDbDataParameter[] Params)

• DataTable ApriDT(string SqlCommand, int CommandTimeout, IDbDataParameter[] Params)

• DataTable ApriDT(string SqlCommand, int CommandTimeout = 30, bool ExecuteFillSchema = true)

• DataTable ApriDT(string SqlCommand, CommandType TipoComando, int CommandTimeout = 30, bool ExecuteFillSchema = true)

• DataTable ApriDT(string SqlCommand, bool vReadOnly, int CommandTimeout = 30, bool ExecuteFillSchema = true)

• DataTable ApriDT(bool vReadOnly, string SqlCommand, bool ExecuteFillSchema = false, int CommandTimeout = 30)

• DataTable? ApriDT(string PathFile, string Separatore, bool AutoDetectedEncoding = true, string DefaultEncoding = "UTF-8")

• DataTable? ApriDT(string PathFile, BCodificaTracciato Codifica, bool AutoDetectedEncoding = true, string DefaultEncoding = "UTF-8")

• DataTable? ApriDT(BFile f, string Separatore, bool OnlyHeader, bool AutoDetectedEncoding = true, string DefaultEncoding = "UTF-8")

• DataTable? ApriDT(string PathFile, string Separatore, string EOF, bool WithTypeIntoHeader, string SeparatoreHeader = "~", bool AutoDetectedEncoding = true, string DefaultEncoding = "UTF-8")

• void BeginTrans()

• void ChiudiDatabase()

• void ClearParameter()

• IBConnection Clone()

• void CommitTrans()

• void EndTrans()

• int ExecuteNonQuery(string SQLCommand, int CommandTimeout = 30)

• int ExecuteNonQuery(string SQLCommand, CommandType TipoComando, int CommandTimeout = 30)

• object? ExecuteScalar(string SQLCommand, int CommandTimeout = 30)

• object? ExecuteScalar(string SQLCommand, CommandBehavior ComportamentoComando, int CommandTimeout = 30)

• object? ExecuteScalar(string SQLCommand, CommandType TipoComando, int CommandTimeout = 30)

• object? ExecuteScalar(string SQLCommand, CommandType TipoComando, CommandBehavior ComportamentoComando, int CommandTimeout = 30)

• bool InsertDT(DataTable dt, string NomeTblDestination, BColumnBind[] ColsBind)

• bool InsertDT(DataTable dt, string NomeTblDestination, bool DisabledIdentityInsert, BColumnBind[] ColsBind)

• bool InsertDT(DataTable dt, string NomeTblDestination, IDbTransaction Transaction, BColumnBind[] ColsBind)

• IDbDataParameter NewDBDataParameter(string Nome, object? Value)

• bool RemoveParameter(string ParamName)

• void RollBackTrans()

• Exception? ScriviFile(DataTable mbDt, string PathFile, string Separatore, string DefaultEncoding = "UTF-8")

• Exception? ScriviFile(DataTable mbDt, string PathFile, BCodificaTracciato Codifica, string DefaultEncoding = "UTF-8")

• Exception? ScriviFile(DataTable mbDt, string PathFile, string Separatore, string EOF, bool WithHeader, bool AddTypeColumnIntoHeader, string SepratoreTypeColumn = "~", string DefaultEncoding = "UTF-8")

Esempi

Consultare IBConnection - Esempi.