C# Класс DbDictExport.Core.Dal.DataAccess

DataAccess class for get the database data.
Показать файл Открыть проект

Открытые методы

Метод Описание
GetDbColumnList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, DbTable table ) : List

Gets a list of DbColumn.
GetDbColumnList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string tableName ) : List

Gets a list of dbColumn.
GetDbNameList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder ) : List

Gets a list of database name.
GetDbTableListWithColumns ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName ) : List

Gets a list of dbTable.
GetDbTableNameListWithoutColumns ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName ) : List

Gets a list of datatable name.
GetResultSetByDbTable ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, DbTable table ) : DataTable

Gets a dataTable of the top 500 columns.
GetTableByName ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName, string tableName ) : DbTable

Gets a dbTable.

Описание методов

GetDbColumnList() публичный статический Метод

Gets a list of DbColumn.
public static GetDbColumnList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, DbTable table ) : List
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
table DbTable The specified dbTable. table.Name cannot be empty.
Результат List

GetDbColumnList() публичный статический Метод

Gets a list of dbColumn.
public static GetDbColumnList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string tableName ) : List
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
tableName string The specified data table name.
Результат List

GetDbNameList() публичный статический Метод

Gets a list of database name.
public static GetDbNameList ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder ) : List
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
Результат List

GetDbTableListWithColumns() публичный статический Метод

Gets a list of dbTable.
public static GetDbTableListWithColumns ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName ) : List
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
dbName string The specified datatable name.
Результат List

GetDbTableNameListWithoutColumns() публичный статический Метод

Gets a list of datatable name.
public static GetDbTableNameListWithoutColumns ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName ) : List
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
dbName string The specified database name.
Результат List

GetResultSetByDbTable() публичный статический Метод

Gets a dataTable of the top 500 columns.
public static GetResultSetByDbTable ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, DbTable table ) : DataTable
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
table DbTable The specified dbTable.
Результат System.Data.DataTable

GetTableByName() публичный статический Метод

Gets a dbTable.
public static GetTableByName ( System.Data.SqlClient.SqlConnectionStringBuilder connBuilder, string dbName, string tableName ) : DbTable
connBuilder System.Data.SqlClient.SqlConnectionStringBuilder The specified SqlConnectionStringBuilder.
dbName string The specified database name.
tableName string The specified datatable name.`
Результат DbTable