public void SQLServerConnector() { using (var connection = new SQLServer(_msSqlConnection)) { try { connection.ExecuteNonQuery($@"CREATE TABLE [dbo].[TestTable]([id] int primary key,[value] nvarchar(255))"); for (var iter = 0; iter < 10; iter++) { var affectedCreate = connection.ExecuteNonQuery(@"INSERT INTO [dbo].[TestTable]([id],[value]) VALUES(@id,@value)", new[] { new SqlParameter("id", iter), new SqlParameter("value", "test") }); Assert.AreEqual(affectedCreate, 1); var selectedById = connection.ExecuteReader <TestTable>(@"SELECT * FROM [dbo].[TestTable] WHERE [id] = @id", new[] { new SqlParameter("id", iter) }); Assert.AreEqual(selectedById.First().id, iter); Assert.AreEqual(selectedById.First().value, "test"); var selectedByIdDynamic = connection.ExecuteReader(@"SELECT * FROM [dbo].[TestTable] WHERE [id] = @id", new[] { new SqlParameter("id", iter) }); Assert.AreEqual(selectedByIdDynamic.First().id, iter); Assert.AreEqual(selectedByIdDynamic.First().value, "test"); var affectedUpdate = connection.ExecuteNonQuery(@"UPDATE [dbo].[TestTable] SET [value] = @value WHERE [id] = @id", new[] { new SqlParameter("id", iter), new SqlParameter("value", "updated") }); Assert.AreEqual(affectedUpdate, 1); var affectedDelete = connection.ExecuteNonQuery(@"DELETE FROM [dbo].[TestTable] WHERE [id] = @id", new[] { new SqlParameter("id", iter) }); Assert.AreEqual(affectedDelete, 1); } var affectedSelectScalar = connection.ExecuteScalar <int>(@"SELECT COUNT(1) FROM [dbo].[TestTable]"); Assert.AreEqual(affectedSelectScalar, 0); Assert.Pass(); } finally { connection.ExecuteNonQuery($@"DROP TABLE [dbo].[TestTable]"); } } }
static async Task Main(string[] args) { bool train = true; //await BinaryClassifier(train); //await MulticlassClassificationExample(train); //await RegressionExample(train); //await ClusteringExample(train); var sqlConnection = $@"Server = localhost;database = Local;user = sa;password = sa"; using (var connector = new SQLServer(sqlConnection)) { var taxiFares = connector.ExecuteReader <TaxiFare>($@"SELECT TOP(10) * FROM [taxi-fare-train]"); foreach (var obj in taxiFares) { //var obj = taxiFares.FirstOrDefault(); Console.WriteLine(obj.fare_amount); obj.fare_amount = 9999; var affectedRow = connector.Update(obj); } } Console.WriteLine("Done"); Console.ReadLine(); }
public void GetDataTest() { SQLServer objDB = null; try { objDB = TestEnvJudge(); if (objDB != null) { if (objDB.Connect()) { DataTable dataTable = objDB.ExecuteReader("SELECT * FROM get_test"); } } } finally { if (objDB.Connect()) { objDB.Disconnect(); } objDB = null; } }