protected override void CreateTable()
{
DataBaseContext.ExecuteCommand(string.Format(@"
CREATE TABLE {0}(
OID Int NOT NULL IDENTITY,
Sent DateTime,
HasAttachment Bit,
Size BigInt,
[From] NVarChar(100),
Subject NVarChar(100),
CONSTRAINT {0}_pk PRIMARY KEY (OID)
);
", TableName));
}
protected override void CreateTable()
{
DataBaseContext.ExecuteCommand(string.Format(@"
CREATE TABLE {0}(
[PersonID] [int] NOT NULL IDENTITY,
[FullName] [nvarchar](max) NULL,
[Company] [nvarchar](max) NULL,
[JobTitle] [nvarchar](max) NULL,
[City] [nvarchar](max) NULL,
[Address] [nvarchar](max) NULL,
[Phone] [nvarchar](max) NULL,
[Email] [nvarchar](max) NULL,
CONSTRAINT {0}_pk PRIMARY KEY (PersonID)
);
", TableName));
}
protected override void Clear()
{
DataBaseContext.ExecuteCommand("DELETE FROM " + TableName + " WHERE Oid>=0");
}
void CreateIndex(string fieldName)
{
DataBaseContext.ExecuteCommand(string.Format(@"CREATE INDEX {1}_idx ON {0} ([{1}]);", TableName, fieldName));
}
protected override void Clear()
{
DataBaseContext.ExecuteCommand("DELETE FROM " + TableName + " WHERE PersonID>=0");
DataBaseContext.ExecuteCommand(string.Format("DBCC CHECKIDENT('{0}', RESEED, 0)", TableName));
}
