C# Class lw_common.db_util

Show file Open project: jtorjo/logwizard

Public Methods

Method	Description
create_db_connection ( string db_provider, string db_connection_string ) : DbConnection
db_connection_type_to_db_provider ( string connection_type ) : string
insert_into_to_db_fields ( string sql ) : List
non_null_dt ( System.Data.Common.DbDataReader rs, int idx ) : System.DateTime
non_null_int ( System.Data.Common.DbDataReader rs, int idx ) : int
non_null_str ( System.Data.Common.DbDataReader rs, int idx ) : string
sqlite_db_table_fields ( string db_name, string table_name ) : List
sqlite_db_tables ( string db_name ) : List

Private Methods

Method	Description
to_db_field_name ( string name ) : string

Method Details

create_db_connection() public static method

public static create_db_connection ( string db_provider, string db_connection_string ) : DbConnection
db_provider	string
db_connection_string	string
return	System.Data.Common.DbConnection

db_connection_type_to_db_provider() public static method

public static db_connection_type_to_db_provider ( string connection_type ) : string
connection_type	string
return	string

insert_into_to_db_fields() public static method

public static insert_into_to_db_fields ( string sql ) : List
sql	string
return	List

non_null_dt() public static method

public static non_null_dt ( System.Data.Common.DbDataReader rs, int idx ) : System.DateTime
rs	System.Data.Common.DbDataReader
idx	int
return	System.DateTime

non_null_int() public static method

public static non_null_int ( System.Data.Common.DbDataReader rs, int idx ) : int
rs	System.Data.Common.DbDataReader
idx	int
return	int

non_null_str() public static method

public static non_null_str ( System.Data.Common.DbDataReader rs, int idx ) : string
rs	System.Data.Common.DbDataReader
idx	int
return	string

sqlite_db_table_fields() public static method

public static sqlite_db_table_fields ( string db_name, string table_name ) : List
db_name	string
table_name	string
return	List

sqlite_db_tables() public static method

public static sqlite_db_tables ( string db_name ) : List
db_name	string
return	List