using FreeSql;
using FreeSql.DataAnnotations;

using (var fsql = new FreeSqlBuilder()
	.UseConnectionString(DataType.Sqlite, "data source=111.db")
	.UseAutoSyncStructure(true)
	.UseNoneCommandParameter(true)
	.UseMonitorCommand(cmd => Console.WriteLine(cmd.CommandText + "\r\n"))
	.Build())
{
    var table = fsql.CodeFirst.DynamicEntity("user", new TableAttribute { Name = "t_user" })
      .Property("id", typeof(int), new ColumnAttribute { IsIdentity = true, IsPrimary = true })
      .Property("username", typeof(string), new ColumnAttribute { StringLength = 32 })
       .Property("adminIds", typeof(string), new ColumnAttribute { StringLength = -1 })
      .Build();

    //如果有必要，请将 table 缓存起来
    if (fsql.DbFirst.ExistsTable(table.DbName) == false)
        fsql.CodeFirst.SyncStructure(table.Type); //创建表

    var dict = new Dictionary<string, object>();
    dict["username"] = "aaa";
    dict["adminIds"] = ",1,2,3,4,5";
    object obj = table.CreateInstance(dict);
    var insNum = fsql.Insert<object>().AsType(table.Type).AppendData(obj).ExecuteAffrows();
    ///这里输出的sql语句替换参数化的地方是能查询出来的，但是代码返回结果为空数组
    var list = fsql.Select<object>().AsType(table.Type).Where("adminIds like '%,@a,%'", new { a = 1 }).ToList();
    Console.ReadLine();
}