SqlAdmin Class

Nemiro.Data.dll

Class provides access to the methods of database management SQL Server.

Inheritance Hierarchy

System Object
Nemiro.Data.Sql SqlAdmin

Namespace: Nemiro.Data.Sql
Assembly: Nemiro.Data (in Nemiro.Data.dll) Version: 2.11.4.126 (2.11.4.126)

Syntax

public class SqlAdmin : IDisposable

public class SqlAdmin : IDisposable

Public Class SqlAdmin 
	Implements IDisposable

Public Class SqlAdmin 
	Implements IDisposable

The SqlAdmin type exposes the following members.

Constructors

	Name	Description
	SqlAdmin	Initializes a new instance of the SqlAdmin class with default settings.
	SqlAdmin(String)	Initializes a new instance of the SqlAdmin class with connection string.

Methods

	Name	Description
	ClearTable	Deletes all data from the specified table. Used TRUNCATE TABLE.
	CreateTable(DataSet, Boolean)	Creates tables specified in the instance of DataSet.
	CreateTable(DataTable, Boolean)	Creates a table in the database.
	DeleteTable	Removes the specified table from the database.
	Dispose	Releases all resources used by the object.
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetAllTables	Returns a list of all the tables that are in the database.
	GetAllTablesName	Returns the names of all the tables that exist in the database.
	GetAllTablesSize	Returns the size of the database tables.
	GetHashCode	(Inherited from Object.)
	GetSqlServerProperty	Returns the value of the specified property instance SQL Server.
	GetSqlServerProprty	Returns the value of the specified property instance SQL Server.
	GetSqlServerVersion	Returns the version of the instance SQL Server.
	GetTableColums	Returns a list of all the columns of specified table.
	GetTablePrimaryKey	Returns a primary key of specified table.
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	ResetIdentity	Reset value of autoincrement field.
	SetIdentityValue	Set new start value for autoincrement field.
	TableIsExists(String)	Checks the existence of a specific table in the database.
	TableIsExists(String, String)	Checks the existence of a specific table in the database.
	ToString	(Inherited from Object.)

Properties

	Name	Description
	ConnectionString	Connection string. Default value: LocalSqlServer.