NShape Reference
SqlStore Class

<< Click to Display Table of Contents >>

Navigation:  Class Reference > Namespace Dataweb.NShape >

NShape Reference
SqlStore Class

Previous pageReturn to chapter overviewNext page

Store implementation for MS SQL Server.

Syntax

public class SqlStore : AdoNetStore

Description

Public Properties

Name

Description

DatabaseName

Specifies the name of the SQL database.

ServerName

Specifies the name of the SQL server instance.

Version

Specifies the main version of the storage format.

Public Methods

Name

Description

CreateDbCommands

Creates the actual SQL commands for the store database. This method has to be overridden.

GetInsertSysCommandCommand

Retrieves a command text for inserting a command into the database.

GetInsertSysParameterCommand

Retrieves a command for inserting command parameters into the database.

Constructors

Construct a new SqlStore instance.

Protected Methods

Name

Description

CalcConnectionString

Creates a connection string for a SqlConnection.

CreateCreateTablesCommand

Creates an SQL command for creating the database schema.

CreateDropTablesCommand

Creates an SQL command for dropping the database schema.

DbTypeForDotNetType

Returns a suitable System.Data.DbType for the given System.Type.

SqlTybleNameForEntityName

Calculates a valid SQL table name from the given entity type name.

SqlTypeForDotNetType

Returns a suitable SQL data type keyword for the given System.Type.

Requirements

Namespace: Dataweb.NShape

Assembly: Dataweb.NShape