public void ShouldCreateMsSqlUtilitiesAndHaveEngineBuilt()
{
var subject = new MsSqlConnection();
MsSqlUtilities withConnectionString = subject.WithConnectionString("Server=.;Initial Catalog=test;Integrated Security=SSPI;");
Assert.That(withConnectionString._engine, Is.Not.Null);
Assert.That(withConnectionString._engine.ConnectionString, Is.Not.Null);
Assert.That(withConnectionString._engine.ConnectionString.InitialCatalog, Is.EqualTo("test"));
}
private void InitConnectionPropertys()
{
ConnectionDefinition = new MsSqlConnection();
const string defaultText = "Set elsewhere";
ConnectionDefinition.Server = defaultText;
ConnectionDefinition.Catalog = defaultText;
ConnectionDefinition.User = defaultText;
ConnectionDefinition.Password = defaultText;
ConnectionDefinition.UseWindowsAuthentication = false;
}
private static IConnectionDefinition ConParLocalExpressDomainUser()
{
var connection = new MsSqlConnection
{
Server = ".\\SQLEXPRESS",
Catalog = "WkstStPlan",
UseWindowsAuthentication = true,
MultipleActiveResultsets = true
};
return(connection);
}
private static IConnectionDefinition ConParHqHome()
{
var connection = new MsSqlConnection
{
Server = "HQDATABASES01\\MSSQL2016_DEV",
Catalog = "WkstStPlan",
UseWindowsAuthentication = true,
MultipleActiveResultsets = true
};
return(connection);
}
public override async Task <ITestAggregateReadModel> GetTestAggregateReadModelAsync(IIdentity id)
{
var sql = ReadModelSqlGenerator.CreateSelectSql <MsSqlTestAggregateReadModel>();
var readModels = await MsSqlConnection.QueryAsync <MsSqlTestAggregateReadModel>(
Label.Named("mssql-fetch-test-read-model"),
CancellationToken.None,
sql,
new { AggregateId = id.Value })
.ConfigureAwait(false);
return(readModels.SingleOrDefault());
}
private static IConnectionDefinition ConParHqRemote()
{
var connection = new MsSqlConnection
{
Server = "HQDATABASES01\\MSSQL2016_DEV",
Catalog = "WkstStPlan",
UseWindowsAuthentication = false,
User = "******",
Password = "******",
MultipleActiveResultsets = true
};
return(connection);
}
public static void Main(string[] args)
{
//remote -> "den1.mssql7.gear.host", "DPTest", "dptest", "Me3JyhRLOg-_"
//local -> "DESKTOP-HVUO0CP", "TestDB"
MsSqlConnectionConfig remoteConfig = new MsSqlConnectionConfig("den1.mssql7.gear.host", "DPTest", "dptest", "Me3JyhRLOg-_");
MsSqlConnectionConfig localConfig = new MsSqlConnectionConfig("DESKTOP-HVUO0CP", "TestDB");
MsSqlConnection connection = new MsSqlConnection(remoteConfig);
connection.ConnectAndOpen();
string testSelectQuery = "SELECT * FROM dbo.Players;";
string testInsertQuery = "INSERT INTO dbo.Players (PlayerID,Name,Surname,Age,Nick) VALUES (4,'Gerard','Pique',33,'Lion');";
string testDeleteQuery = "DELETE FROM dbo.Players WHERE PlayerID = 4;";
string output = connection.ExecuteSelectQuery(testSelectQuery);
Console.WriteLine(output);
connection.ExecuteQuery(testInsertQuery);
output = connection.ExecuteSelectQuery(testSelectQuery);
Console.WriteLine(output);
connection.ExecuteQuery(testDeleteQuery);
output = connection.ExecuteSelectQuery(testSelectQuery);
Console.WriteLine(output);
connection.Dispose();
IceDragon iceDragon = new IceDragon(200, "Winterrrer", 10, 20, 20, 50);
GoldDragon goldDragon = new GoldDragon(220, "Sauman", 10, 20, 40, 40);
DataManager mythicalManager = new DataManager();
List <Object> creatures = new List <Object> ()
{
iceDragon, goldDragon
};
List <Object> wizards = new List <Object>()
{
new Wizard("Romas", 10, 2.41)
};
mythicalManager.Inherit(creatures, 0);
mythicalManager.Inherit(wizards, 1);
Console.WriteLine("Utter success");
}
public DataManager(string serverName, string databaseName)
{
MsSqlConnectionConfig config = new MsSqlConnectionConfig(serverName, databaseName);
this._msSqlConnection = new MsSqlConnection(config);
}
public void ShouldCreateMsSqlUtilities()
{
var subject = new MsSqlConnection();
Assert.That(subject.WithConnectionString(""), Is.TypeOf(typeof(MsSqlUtilities)));
}
