BConnection
Linea B-Arts classica: questa scheda descrive
BNetFramework(.NET Framework 4.8). Non usare firme o namespace come se appartenessero alBFrameworkmoderno .NET 10.
Identità
Assembly/progetto:
BNetFramework.Target:
.NET Framework 4.8.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 BConnectionInterfacce dichiarate: IDisposable, IBConnection.
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 |
|---|---|
Transaction |
Public ReadOnly Property Transaction() As IDbTransaction Implements IBConnection.Transaction |
InsertDTTimeout |
Public Property InsertDTTimeout As Integer = 30 Implements IBConnection.InsertDTTimeout |
ExceptionList |
Public ReadOnly Property ExceptionList As List(Of Exception) Implements IBConnection.ExceptionList |
Metodi
| Nome | Dichiarazione |
|---|---|
Dispose |
Public Sub Dispose() Implements IDisposable.Dispose |
ApriDatabase |
Public Sub ApriDatabase() Implements IBConnection.ApriDatabase |
ChiudiDatabase |
Public Sub ChiudiDatabase() Implements IBConnection.ChiudiDatabase |
Clone |
Public Function Clone() As IBConnection Implements IBConnection.Clone |
ExecuteNonQuery |
Public Function ExecuteNonQuery(ByVal SQLCommand As String, Optional ByVal CommandTimeout As Integer = 30) As Integer Implements IBConnection.ExecuteNonQuery |
ExecuteNonQuery |
Public Function ExecuteNonQuery(ByVal SQLCommand As String, ByVal TipoComando As System.Data.CommandType, Optional ByVal CommandTimeout As Integer = 30) As Integer Implements IBConnection.ExecuteNonQuery |
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 Implements IBConnection.ExecuteScalar |
ExecuteScalar |
Public Function ExecuteScalar(ByVal SQLCommand As String, ByVal ComportamentoComando As CommandBehavior, Optional ByVal CommandTimeout As Integer = 30) As Object Implements IBConnection.ExecuteScalar |
ExecuteScalar |
Public Function ExecuteScalar(ByVal SQLCommand As String, ByVal TipoComando As CommandType, Optional ByVal CommandTimeout As Integer = 30) As Object Implements IBConnection.ExecuteScalar |
ExecuteScalar |
Public Function ExecuteScalar(ByVal SQLCommand As String, ByVal TipoComando As CommandType, ByVal ComportamentoComando As CommandBehavior, Optional ByVal CommandTimeout As Integer = 30) As Object Implements IBConnection.ExecuteScalar |
ApriDT |
Public Function ApriDT(ByVal SqlCommand As String, Optional ByVal CommandTimeout As Integer = 30, Optional ByVal ExecuteFillSchema As Boolean = True) As DataTable Implements IBConnection.ApriDT |
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 DataTable Implements IBConnection.ApriDT |
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 DataTable Implements IBConnection.ApriDT |
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 DataTable Implements IBConnection.ApriDT |
ApriDT |
Public Function ApriDT(ByVal SqlCommand As String, ParamArray Params() As IDbDataParameter) As DataTable Implements IBConnection.ApriDT |
ApriDT |
Public Function ApriDT(ByVal SqlCommand As String, CommandTimeout As Integer, ParamArray Params() As IDbDataParameter) As DataTable Implements IBConnection.ApriDT |
ApriDS |
Public Function ApriDS(ByVal SPName As String, Optional ByVal CommandTimeout As Integer = 30) As DataSet Implements IBConnection.ApriDS |
ApriDS |
Public Function ApriDS(ByVal SPName As String, ByVal ParamArray Params() As IDbDataParameter) As DataSet Implements IBConnection.ApriDS |
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 DataTable Implements IBConnection.ApriDT |
ApriDT |
Public Function ApriDT(ByVal PathFile As String, ByVal Separatore As String) As DataTable Implements IBConnection.ApriDT |
ApriDT |
Public Function ApriDT(ByVal PathFile As String, ByVal Codifica As BCodificaTracciato) As DataTable Implements IBConnection.ApriDT |
ApriDT |
Public Function ApriDT(ByVal f As BFile, ByVal Separatore As String, OnlyHeader As Boolean) As DataTable Implements IBConnection.ApriDT |
ApriDT |
Public Function ApriDT(ByVal f As BFile, ByVal Separatore As String, OnlyHeader As Boolean, Decodifica As Text.Encoding) As DataTable Implements IBConnection.ApriDT |
InsertDT |
Public Function InsertDT(dt As DataTable, NomeTblDestination As String, DisabledIdentityInsert As Boolean, ParamArray ColsBind() As BColumnBind) As Boolean Implements IBConnection.InsertDT |
InsertDT |
Public Function InsertDT(dt As DataTable, NomeTblDestination As String, ParamArray ColsBind() As BColumnBind) As Boolean Implements IBConnection.InsertDT |
InsertDT |
Public Function InsertDT(dt As DataTable, NomeTblDestination As String, Transaction As IDbTransaction, ParamArray ColsBind() As BColumnBind) As Boolean Implements IBConnection.InsertDT |
ScriviFile |
Public Function ScriviFile(ByVal mbDt As DataTable, ByVal PathFile As String, ByVal Separatore As String) As Exception Implements IBConnection.ScriviFile |
ScriviFile |
Public Function ScriviFile(ByVal mbDt As DataTable, ByVal PathFile As String, ByVal Codifica As BCodificaTracciato) As Exception Implements IBConnection.ScriviFile |
ScriviFile |
Public Function ScriviFile(ByVal mbDt As DataTable, ByVal PathFile As String, ByVal Separatore As String, EOF As String, WithHeader As Boolean, AddTypeColumnIntoHeader As Boolean, Optional SepratoreTypeColumn As String = "~") As Exception Implements IBConnection.ScriviFile |
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() Implements IBConnection.BeginTrans |
CommitTrans |
Public Sub CommitTrans() Implements IBConnection.CommitTrans |
RollBackTrans |
Public Sub RollBackTrans() Implements IBConnection.RollBackTrans |
EndTrans |
Public Sub EndTrans() Implements IBConnection.EndTrans |
AddParameter |
Public Function AddParameter(ByVal ParamName As String, ByVal ParamValue As Object) As Boolean Implements IBConnection.AddParameter |
AddParameter |
Public Function AddParameter(ByVal Param As IDbDataParameter) As Boolean Implements IBConnection.AddParameter |
AddParameter |
Public Sub AddParameter(ByVal ParamArray Params() As IDbDataParameter) Implements IBConnection.AddParameter |
RemoveParameter |
Public Function RemoveParameter(ByVal ParamName) As Boolean Implements IBConnection.RemoveParameter |
ClearParameter |
Public Sub ClearParameter() Implements IBConnection.ClearParameter |
NewDBDataParameter |
Public Function NewDBDataParameter(Nome As String, Value As Object) As IDbDataParameter Implements IBConnection.NewDBDataParameter |
Sorgenti verificati
Data\BConnection.vb