Interface ISqlColumnService

Revtrieve column-information from a relational database

Namespace: Simplic.Sql

Assembly: Simplic.Sql.dll

Syntax

public interface ISqlColumnService

Methods

GetColumns(String, String)

Retrieves the columns from the database table.

Declaration

IDictionary<string, Type> GetColumns(string tableName, string databaseName)

Parameters

Type	Name	Description
System.String	tableName	Table to read the columns from
System.String	databaseName	Database to read the information from

Returns

Type	Description
System.Collections.Generic.IDictionary<System.String, System.Type>

GetModelDBColumnNames(String, Type, IDictionary<String, String>)

Retrieves the columns from the database table and compares them with the model. Returns only the fields which are found in the model!

Declaration

IDictionary<string, string> GetModelDBColumnNames(string tableName, Type modelType, IDictionary<string, string> differentColumnName)

Parameters

Type	Name	Description
System.String	tableName	Table to read the columns from
System.Type	modelType
System.Collections.Generic.IDictionary<System.String, System.String>	differentColumnName

Returns

Type	Description
System.Collections.Generic.IDictionary<System.String, System.String>

GetModelDBColumnNames(String, Type, IDictionary<String, String>, String)

Retrieves the columns from the database table and compares them with the model. Returns only the fields which are found in the model!

Declaration

IDictionary<string, string> GetModelDBColumnNames(string tableName, Type modelType, IDictionary<string, string> differentColumnName, string databaseName)

Parameters

Type	Name	Description
System.String	tableName	Table to read the columns from
System.Type	modelType
System.Collections.Generic.IDictionary<System.String, System.String>	differentColumnName
System.String	databaseName

Returns

Type	Description
System.Collections.Generic.IDictionary<System.String, System.String>