private void Button5_Click(object sender, EventArgs e)
{
string sqlUserRole = "SELECT * FROM SMART_BD_USERROLE";
// string sqlOrderDetail = "SELECT * FROM OrderDetails WHERE OrderDetailID = @OrderDetailID;";
// string sqlCustomerInsert = "INSERT INTO Customers (CustomerName) Values (@CustomerName);";
using (var connection = new UniConnection("provider=Oracle;User Id=smart;Password=smart;Server=121.40.101.29;Direct=True;Port=1521;Sid=orcl;"))
{
var orderDetails = connection.Query <UserRole>(sqlUserRole).ToList();
// var orderDetail = connection.QueryFirstOrDefault<OrderDetail>(sqlOrderDetail, new { OrderDetailID = 1 });
// var affectedRows = connection.Execute(sqlCustomerInsert, new { CustomerName = "Mark" });
//
// Console.WriteLine(orderDetails.Count);
// Console.WriteLine(affectedRows);
//
// FiddleHelper.WriteTable(orderDetails);
// FiddleHelper.WriteTable(new List<OrderDetail>() { orderDetail });
}
}
