C# Class mojoPortal.Business.DatabaseHelper

Afficher le fichier Open project: joeaudette/mojoportal

Méthodes publiques

Méthode	Description
AddSchemaScriptHistory ( System.Guid applicationId, string scriptFile, System.DateTime runTime, bool errorOccurred, string errorMessage, string scriptBody ) : int
CanAccessDatabase ( ) : bool
CanAlterSchema ( String overrideConnectionInfo ) : bool
DBCodeVersion ( ) : System.Version
DBPlatform ( ) : String
DBSchemaVersion ( ) : System.Version
DeleteSchemaScriptHistory ( int id ) : bool
DeleteSchemaVersion ( System.Guid applicationId ) : bool
DoForumVersion2202PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoForumVersion2203PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoVersion2230PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoVersion2234PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoVersion2247PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoVersion2253PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoVersion2320PostUpgradeTasks ( String overrideConnectionInfo ) : void
EnsureDatabase ( ) : void
ExecteNonQuery ( string query ) : int
ExecteNonQuery ( string connectionString, string query ) : int
ExistingSiteCount ( ) : int
GetApplicationId ( ) : System.Guid
GetApplicationId ( string applicationName ) : System.Guid
GetApplicationName ( ) : String
GetApplicationName ( System.Guid applicationId ) : String
GetConnectionError ( String overrideConnectionInfo ) : DbException
GetReader ( String connectionString, String tableName, String whereClause ) : IDataReader
GetReader ( string query ) : IDataReader
GetReader ( string connectionString, string query ) : IDataReader
GetSchemaScriptErrorHistory ( System.Guid applicationId ) : IDataReader
GetSchemaScriptHistory ( System.Guid applicationId ) : IDataReader
GetSchemaScriptHistory ( int id ) : IDataReader
GetSchemaVersion ( System.Guid applicationId ) : System.Version
GetSchemaVersion ( string applicationName ) : System.Version
GetTable ( String connectionString, String tableName, String whereClause ) : DataTable
GetTableFromDataReader ( IDataReader reader ) : DataTable
ParseVersionFromFileName ( String fileName ) : System.Version
RunScript ( System.Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo ) : string
SchemaHasBeenCreated ( ) : bool
SchemaScriptHasBeenRun ( System.Guid applicationId, String scriptFile ) : bool
SchemaVersionGetNonCore ( ) : IDataReader
UpdateSchemaVersion ( System.Guid applicationId, string applicationName, int major, int minor, int build, int revision ) : bool
UpdateTableField ( String tableName, String keyFieldName, String keyFieldValue, String dataFieldName, String dataFieldValue, String additionalWhere ) : bool
UpdateTableField ( String connectionString, String tableName, String keyFieldName, String keyFieldValue, String dataFieldName, String dataFieldValue, String additionalWhere ) : bool

Method Details

AddSchemaScriptHistory() public static méthode

public static AddSchemaScriptHistory ( System.Guid applicationId, string scriptFile, System.DateTime runTime, bool errorOccurred, string errorMessage, string scriptBody ) : int
applicationId	System.Guid
scriptFile	string
runTime	System.DateTime
errorOccurred	bool
errorMessage	string
scriptBody	string
Résultat	int

CanAccessDatabase() public static méthode

public static CanAccessDatabase ( ) : bool
Résultat	bool

CanAlterSchema() public static méthode

public static CanAlterSchema ( String overrideConnectionInfo ) : bool
overrideConnectionInfo	String
Résultat	bool

DBCodeVersion() public static méthode

public static DBCodeVersion ( ) : System.Version
Résultat	System.Version

DBPlatform() public static méthode

public static DBPlatform ( ) : String
Résultat	String

DBSchemaVersion() public static méthode

public static DBSchemaVersion ( ) : System.Version
Résultat	System.Version

DeleteSchemaScriptHistory() public static méthode

public static DeleteSchemaScriptHistory ( int id ) : bool
id	int
Résultat	bool

DeleteSchemaVersion() public static méthode

public static DeleteSchemaVersion ( System.Guid applicationId ) : bool
applicationId	System.Guid
Résultat	bool

DoForumVersion2202PostUpgradeTasks() public static méthode

public static DoForumVersion2202PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
Résultat	void

DoForumVersion2203PostUpgradeTasks() public static méthode

public static DoForumVersion2203PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
Résultat	void

DoVersion2230PostUpgradeTasks() public static méthode

public static DoVersion2230PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
Résultat	void

DoVersion2234PostUpgradeTasks() public static méthode

public static DoVersion2234PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
Résultat	void

DoVersion2247PostUpgradeTasks() public static méthode

public static DoVersion2247PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
Résultat	void

DoVersion2253PostUpgradeTasks() public static méthode

public static DoVersion2253PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
Résultat	void

DoVersion2320PostUpgradeTasks() public static méthode

public static DoVersion2320PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
Résultat	void

EnsureDatabase() public static méthode

public static EnsureDatabase ( ) : void
Résultat	void

ExecteNonQuery() public static méthode

public static ExecteNonQuery ( string query ) : int
query	string
Résultat	int

ExecteNonQuery() public static méthode

public static ExecteNonQuery ( string connectionString, string query ) : int
connectionString	string
query	string
Résultat	int

ExistingSiteCount() public static méthode

public static ExistingSiteCount ( ) : int
Résultat	int

GetApplicationId() public static méthode

public static GetApplicationId ( ) : System.Guid
Résultat	System.Guid

GetApplicationId() public static méthode

public static GetApplicationId ( string applicationName ) : System.Guid
applicationName	string
Résultat	System.Guid

GetApplicationName() public static méthode

public static GetApplicationName ( ) : String
Résultat	String

GetApplicationName() public static méthode

public static GetApplicationName ( System.Guid applicationId ) : String
applicationId	System.Guid
Résultat	String

GetConnectionError() public static méthode

public static GetConnectionError ( String overrideConnectionInfo ) : DbException
overrideConnectionInfo	String
Résultat	DbException

GetReader() public static méthode

public static GetReader ( String connectionString, String tableName, String whereClause ) : IDataReader
connectionString	String
tableName	String
whereClause	String
Résultat	IDataReader

GetReader() public static méthode

public static GetReader ( string query ) : IDataReader
query	string
Résultat	IDataReader

GetReader() public static méthode

public static GetReader ( string connectionString, string query ) : IDataReader
connectionString	string
query	string
Résultat	IDataReader

GetSchemaScriptErrorHistory() public static méthode

public static GetSchemaScriptErrorHistory ( System.Guid applicationId ) : IDataReader
applicationId	System.Guid
Résultat	IDataReader

GetSchemaScriptHistory() public static méthode

public static GetSchemaScriptHistory ( System.Guid applicationId ) : IDataReader
applicationId	System.Guid
Résultat	IDataReader

GetSchemaScriptHistory() public static méthode

public static GetSchemaScriptHistory ( int id ) : IDataReader
id	int
Résultat	IDataReader

GetSchemaVersion() public static méthode

public static GetSchemaVersion ( System.Guid applicationId ) : System.Version
applicationId	System.Guid
Résultat	System.Version

GetSchemaVersion() public static méthode

public static GetSchemaVersion ( string applicationName ) : System.Version
applicationName	string
Résultat	System.Version

GetTable() public static méthode

public static GetTable ( String connectionString, String tableName, String whereClause ) : DataTable
connectionString	String
tableName	String
whereClause	String
Résultat	System.Data.DataTable

GetTableFromDataReader() public static méthode

public static GetTableFromDataReader ( IDataReader reader ) : DataTable
reader	IDataReader
Résultat	System.Data.DataTable

ParseVersionFromFileName() public static méthode

public static ParseVersionFromFileName ( String fileName ) : System.Version
fileName	String
Résultat	System.Version

RunScript() public static méthode

public static RunScript ( System.Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo ) : string
applicationId	System.Guid
scriptFile	System.IO.FileInfo
overrideConnectionInfo	String
Résultat	string

SchemaHasBeenCreated() public static méthode

public static SchemaHasBeenCreated ( ) : bool
Résultat	bool

SchemaScriptHasBeenRun() public static méthode

public static SchemaScriptHasBeenRun ( System.Guid applicationId, String scriptFile ) : bool
applicationId	System.Guid
scriptFile	String
Résultat	bool

SchemaVersionGetNonCore() public static méthode

public static SchemaVersionGetNonCore ( ) : IDataReader
Résultat	IDataReader

UpdateSchemaVersion() public static méthode

public static UpdateSchemaVersion ( System.Guid applicationId, string applicationName, int major, int minor, int build, int revision ) : bool
applicationId	System.Guid
applicationName	string
major	int
minor	int
build	int
revision	int
Résultat	bool

UpdateTableField() public static méthode

public static UpdateTableField ( String tableName, String keyFieldName, String keyFieldValue, String dataFieldName, String dataFieldValue, String additionalWhere ) : bool
tableName	String
keyFieldName	String
keyFieldValue	String
dataFieldName	String
dataFieldValue	String
additionalWhere	String
Résultat	bool

UpdateTableField() public static méthode

public static UpdateTableField ( String connectionString, String tableName, String keyFieldName, String keyFieldValue, String dataFieldName, String dataFieldValue, String additionalWhere ) : bool
connectionString	String
tableName	String
keyFieldName	String
keyFieldValue	String
dataFieldName	String
dataFieldValue	String
additionalWhere	String
Résultat	bool