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