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