public void TestSqlServer()
{
/*
* C:\>sqlcmd -S .\SQLEXPRESS
* > create login [bor\ktarbet] from windows
* select loginname from master..syslogins
* > go
* sp_addsrvrolemember @loginame='bor\ktarbet' , @rolename='sysadmin'
* > ;
*/
string cStr = "integrated security=SSPI;data source=localhost\\SQLEXPRESS;Database=master";
var svr = new SqlServer(cStr);
var tmp = svr.Table("exists", " SELECT name FROM master..sysdatabases where name = 'test_pisces'");
if (tmp.Rows.Count == 1)
{
svr.CloseAllConnections();
svr.DeleteDataBase("test_pisces");
}
Console.WriteLine("about to create database");
svr.CreateDataBase("test_pisces");
svr = new SqlServer(cStr.Replace("master", "test_pisces"));
TimeSeriesDatabase db = new TimeSeriesDatabase(svr, false);
BasicDatabaseTest(db);
}
public void TestSqlServer()
{
/*
* C:\>sqlcmd -S .\SQLEXPRESS
> create login [bor\ktarbet] from windows
* select loginname from master..syslogins
> go
sp_addsrvrolemember @loginame='bor\ktarbet' , @rolename='sysadmin'
> ;
*/
string cStr ="integrated security=SSPI;data source=localhost\\SQLEXPRESS;Database=master";
var svr = new SqlServer(cStr);
var tmp = svr.Table("exists", " SELECT name FROM master..sysdatabases where name = 'test_pisces'");
if (tmp.Rows.Count == 1)
{
svr.CloseAllConnections();
svr.DeleteDataBase("test_pisces");
}
Console.WriteLine("about to create database");
svr.CreateDataBase("test_pisces");
svr = new SqlServer(cStr.Replace("master","test_pisces"));
TimeSeriesDatabase db = new TimeSeriesDatabase(svr,false);
BasicDatabaseTest(db);
}