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