public void TestSelect()
{
var connection = new MySql.Data.MySqlClient.MySqlConnection("server=localhost;user id=root;password=1024;database=test;");
using (IDbContext db = new DbProxyContext(connection, DbContextType.Mysql))
{
db.Open();
var list0 = db.From <Student>().Select(s => SqlFun.CONCAT(s.Name, s.Score)).ToList();
var list1 = db.From <Student>().Select().ToList();
var list2 = db.From <Student>().Where(a => a.IsDelete == false).Select().ToList();
var list3 = db.From <Student>().OrderBy(a => a.Id).OrderByDescending(a => a.Balance).Select().ToList();
var list4 = db.From <Student>().Take(4).Select().ToList();
var list5 = db.From <Student>().Take(4).Skip(2, 2).Select().ToList();
var list6 = db.From <Student>().Select(s => new { s.IsDelete, s.Id, s.Name }).ToList();
var list7 = db.From <Student>().Select(s => new Student {
IsDelete = s.IsDelete, Id = s.Id, Name = s.Name
}).ToList();
}
}
public void TestSelect()
{
var connection = new Npgsql.NpgsqlConnection("Server=127.0.0.1;Port=5432;User Id=postgres;Password=1024;Database=test;");
using (IDbContext db = new DbProxyContext(connection, DbContextType.Postgresql))
{
db.Open();
var list0 = db.From <Student>().Select(s => SqlFun.CONCAT(s.Name, s.Score)).ToList();
var list1 = db.From <Student>().Select().ToList();
var list2 = db.From <Student>().Where(a => a.IsDelete == false).Select().ToList();
var list3 = db.From <Student>().OrderBy(a => a.Id).OrderByDescending(a => a.Balance).Select().ToList();
var list4 = db.From <Student>().Take(4).Select().ToList();
var list5 = db.From <Student>().Take(4).Skip(2, 2).Select().ToList();
var list6 = db.From <Student>().Select(s => new { s.IsDelete, s.Id, s.Name }).ToList();
var list7 = db.From <Student>().Select(s => new Student {
IsDelete = s.IsDelete, Id = s.Id, Name = s.Name
}).ToList();
}
}
public void TestSelect()
{
var connection = new System.Data.SqlClient.SqlConnection(@"Data Source=DESKTOP-9IS2HA6\SQLEXPRESS;Initial Catalog=test;Persist Security Info=True;User ID=sa;Password=1024");
using (IDbContext db = new DbProxyContext(connection, DbContextType.SqlServer))
{
db.Open();
var list0 = db.From <Student>().Select(s => SqlFun.CONCAT(s.Name, s.Score)).ToList();
var list1 = db.From <Student>().Select().ToList();
var list2 = db.From <Student>().Where(a => a.IsDelete == false).Select().ToList();
var list3 = db.From <Student>().OrderBy(a => a.Id).OrderByDescending(a => a.Balance).Select().ToList();
var list4 = db.From <Student>().Take(4).Select().ToList();
var list5 = db.From <Student>().Take(4).Skip(2, 2).Select().ToList();
var list6 = db.From <Student>().Select(s => new { s.IsDelete, s.Id, s.Name }).ToList();
var list7 = db.From <Student>().Select(s => new Student {
IsDelete = s.IsDelete, Id = s.Id, Name = s.Name
}).ToList();
}
}
