C# (CSharp) IConnManager.GetDataTable Examples

Example #1

File: TestsSqlClientConnManager.cs Project: RobertLeisner/Bodoconsult.Core.Database.SqlClient

        public void TestGetDataTableFromSql()
        {
            const string sql = "SELECT * FROM dbo.Customer";

            var erg = _db.GetDataTable(sql);

            Assert.IsTrue(erg.Rows.Count > 0);
        }

Example #2

File: UnitTestPostgresConnManager.cs Project: RobertLeisner/Bodoconsult.Core.Database.Postgres

        public void TestGetDataTableSql()
        {
            // Assert
            var sql = "SELECT * FROM \"Customer\";";

            // Act
            var result = _db.GetDataTable(sql);

            // Assert
            Assert.IsNotNull(result);
        }