BConnection

Linea B-Arts Legacy: questa scheda descrive BArtsFrameworkStandard (.NET Standard 2.0). Non usare firme o namespace come se appartenessero alla linea Classic successiva o al BFramework moderno .NET 10.

Identità

Assembly/progetto: BArtsFrameworkStandard.
Target: .NET Standard 2.0.
Namespace CLR: BArts.BData.
Nome completo: BArts.BData.BConnection.
Tipo: class.
Ambito: runtime/interfaccia pubblica.

Ruolo

Connessione SQL Server classica. Gestisce parametri, transazioni, lettura di DataTable/DataSet, comandi e importazioni massive.

Dichiarazione

Public Class BConnection

Interfacce dichiarate: IDisposable.

Costruttori

Nome	Dichiarazione
`New`	`Public Sub New()`
`New`	`Public Sub New(ByVal NomeServer As String, ByVal NomeDB As String, ByVal Utente As String, ByVal Password As String)`
`New`	`Public Sub New(ByVal objSet As BSettingDatabase)`

Proprietà

Nome	Dichiarazione
`Transiction`	`<Obsolete("Proprieta non più supportata. Utilizzare la proprietà Transaction")> Public ReadOnly Property Transiction() As Object`
`Transaction`	`Public ReadOnly Property Transaction() As IDbTransaction`
`InsertDTTimeout`	`Public Property InsertDTTimeout As Integer = 30`
`ExceptionList`	`Public ReadOnly Property ExceptionList As List(Of Exception)`

Metodi

Nome	Dichiarazione
`Dispose`	`Public Sub Dispose() Implements IDisposable.Dispose`
`ApriDatabase`	`Public Sub ApriDatabase()`
`ChiudiDatabase`	`Public Sub ChiudiDatabase()`
`Clone`	`Public Function Clone() As BConnection`
`ExecuteNonQuery`	`Public Function ExecuteNonQuery(ByVal SQLCommand As String, Optional ByVal CommandTimeout As Integer = 30) As Integer`
`ExecuteNonQuery`	`Public Function ExecuteNonQuery(ByVal SQLCommand As String, ByVal TipoComando As System.Data.CommandType, Optional ByVal CommandTimeout As Integer = 30) As Integer`
`Execute`	`Public Function Execute(ByVal SQLCommand As String, Optional ByVal CommandTimeout As Integer = 30) As BDataReader`
`Execute`	`Public Function Execute(ByVal SQLCommand As String, ByVal ComportamentoComando As System.Data.CommandBehavior, Optional ByVal CommandTimeout As Integer = 30) As BDataReader`
`Execute`	`Public Function Execute(ByVal SQLCommand As String, ByVal TipoComando As System.Data.CommandType, Optional ByVal CommandTimeout As Integer = 30) As BDataReader`
`Execute`	`Public Function Execute(ByVal SQLCommand As String, ByVal TipoComando As System.Data.CommandType, ByVal ComportamentoComando As System.Data.CommandBehavior, Optional ByVal CommandTimeout As Integer = 30) As BDataReader`
`ExecuteScalar`	`Public Function ExecuteScalar(ByVal SQLCommand As String, Optional ByVal CommandTimeout As Integer = 30) As Object`
`ExecuteScalar`	`Public Function ExecuteScalar(ByVal SQLCommand As String, ByVal ComportamentoComando As System.Data.CommandBehavior, Optional ByVal CommandTimeout As Integer = 30) As Object`
`ExecuteScalar`	`Public Function ExecuteScalar(ByVal SQLCommand As String, ByVal TipoComando As System.Data.CommandType, Optional ByVal CommandTimeout As Integer = 30) As Object`
`ExecuteScalar`	`Public Function ExecuteScalar(ByVal SQLCommand As String, ByVal TipoComando As System.Data.CommandType, ByVal ComportamentoComando As System.Data.CommandBehavior, Optional ByVal CommandTimeout As Integer = 30) As Object`
`ApriDT`	`Public Function ApriDT(ByVal SqlCommand As String, Optional ByVal CommandTimeout As Integer = 30, Optional ByVal ExecuteFillSchema As Boolean = True) As BDataTable`
`ApriDT`	`Public Function ApriDT(ByVal SqlCommand As String, ByVal TipoComando As CommandType, Optional ByVal CommandTimeout As Integer = 30, Optional ByVal ExecuteFillSchema As Boolean = True) As BDataTable`
`ApriDT`	`Public Function ApriDT(ByVal SqlCommand As String, ByVal vReadOnly As Boolean, Optional ByVal CommandTimeout As Integer = 30, Optional ByVal ExecuteFillSchema As Boolean = True) As BDataTable`
`ApriDT`	`Public Function ApriDT(ByVal vReadOnly As Boolean, ByVal SqlCommand As String, Optional ByVal ExecuteFillSchema As Boolean = False, Optional ByVal CommandTimeout As Integer = 30) As BDataTable`
`ApriDT`	`Public Function ApriDT(ByVal SqlCommand As String, ParamArray Params() As IDbDataParameter) As BDataTable`
`ApriDT`	`Public Function ApriDT(ByVal SqlCommand As String, CommandTimeout As Integer, ParamArray Params() As IDbDataParameter) As BDataTable`
`ApriDS`	`Public Function ApriDS(ByVal SPName As String, Optional ByVal CommandTimeout As Integer = 30) As BDataSet`
`ApriDS`	`Public Function ApriDS(ByVal SPName As String, ByVal ParamArray Params() As SqlClient.SqlParameter) As BDataSet`
`ApriDV`	`Public Function ApriDV(ByVal SqlCommand As String, Optional ByVal CommandTimeout As Integer = 30) As DataView`
`ApriDV`	`Public Function ApriDV(ByVal SqlCommand As String, ByVal vReadOnly As Boolean, Optional ByVal CommandTimeout As Integer = 30) As DataView`
`ApriDV`	`Public Function ApriDV(ByVal mbDt As BDataTable) As DataView`
`ApriDT`	`Public Function ApriDT(ByVal PathFile As String, ByVal Separatore As String, EOF As String, WithTypeIntoHeader As Boolean, Optional SeparatoreHeader As String = "~") As BDataTable`
`ApriDT`	`Public Function ApriDT(ByVal PathFile As String, ByVal Separatore As String) As BDataTable`
`ApriDT`	`Public Function ApriDT(ByVal PathFile As String, ByVal Codifica As BCodificaTracciato)`
`ApriDT`	`Public Function ApriDT(ByVal f As BFile, ByVal Separatore As String, OnlyHeader As Boolean) As BDataTable`
`ApriDT`	`Public Function ApriDT(ByVal f As BFile, ByVal Separatore As String, OnlyHeader As Boolean, Decodifica As Text.Encoding) As BDataTable`
`InsertDT`	`Public Function InsertDT(dt As BDataTable, NomeTblDestination As String, DisabledIdentityInsert As Boolean, ParamArray ColsBind() As BColumnBind) As Boolean`
`InsertDT`	`Public Function InsertDT(dt As BDataTable, NomeTblDestination As String, ParamArray ColsBind() As BColumnBind) As Boolean`
`InsertDT`	`Public Function InsertDT(dt As BDataTable, NomeTblDestination As String, Transaction As SqlTransaction, ParamArray ColsBind() As BColumnBind) As Boolean`
`ScriviFile`	`Public Function ScriviFile(ByVal mbDt As BDataTable, ByVal PathFile As String, ByVal Separatore As String) As System.Exception`
`ScriviFile`	`Public Function ScriviFile(ByVal mbDt As BDataTable, ByVal PathFile As String, ByVal Codifica As BCodificaTracciato) As System.Exception`
`ScriviFile`	`Public Function ScriviFile(ByVal mbDt As BDataTable, ByVal PathFile As String, ByVal Separatore As String, EOF As String, WithHeader As Boolean, AddTypeColumnIntoHeader As Boolean, Optional SepratoreTypeColumn As String = "~") As System.Exception`
`DammiCampoTbl`	`Public Function DammiCampoTbl(Campo As String, Tbl As String, Optional Condizione As String = "") As Object`
`DammiCampoTbl`	`Public Function DammiCampoTbl(Campo As String, Tbl As String, Optional Condizione As String = "", Optional NothingValue As String = "") As String`
`DammiCampoTbl`	`Public Function DammiCampoTbl(Campo As String, Tbl As String, Optional Condizione As String = "", Optional NothingValue As Integer = -1) As Integer`
`BeginTrans`	`Public Sub BeginTrans()`
`CommitTrans`	`Public Sub CommitTrans()`
`RollBackTrans`	`Public Sub RollBackTrans()`
`EndTrans`	`Public Sub EndTrans()`
`AddParameter`	`Public Function AddParameter(ByVal ParamName As String, ByVal ParamValue As Object) As Boolean`
`AddParameter`	`Public Sub AddParameter(ByVal Param As IDbDataParameter)`
`AddParameter`	`Public Sub AddParameter(ByVal ParamArray Params() As IDbDataParameter)`
`RemoveParameter`	`Public Function RemoveParameter(ByVal ParamName) As Boolean`
`ClearParameter`	`Public Sub ClearParameter()`

Sorgenti verificati

Data\BConnection.vb