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)); }