NShape Reference
SqlStore Class

<< Click to Display Table of Contents >>

Navigation: Class Reference > Namespace Dataweb.NShape >

NShape Reference
SqlStore Class

Previous page

Return to chapter overview

Next 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