BConnection
Linea B-Arts Legacy: questa scheda descrive
B-ArtsFramework(.NET Framework 4.7.2). Non usare firme o namespace come se appartenessero alla linea Classic successiva o alBFrameworkmoderno .NET 10.
Identità
Assembly/progetto:
B-ArtsFramework.Target:
.NET Framework 4.7.2.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.
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 |
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