sqlkata / querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
https://sqlkata.com
MIT License
3.09k stars 498 forks source link

How can we use T_HAZIRMETIN table name and column name in QueryBuilder. without using nameof. #533

Closed mummyildiz closed 2 years ago

mummyildiz commented 2 years ago

public class T_HAZIRMETIN { public string TID { get; set; } public string TANAHTAR { get; set; }
}


            var q = db.Query(nameof(DbTables.Entities.T_HAZIRMETIN))
                         .Where(nameof(DbTables.Entities.T_HAZIRMETIN.TID), ">", 0)
                         .WhereIn(nameof(DbTables.Entities.T_HAZIRMETIN.TID), new[] { 1, 2 })
                         .OrderByDesc(nameof(DbTables.Entities.T_HAZIRMETIN.TID))
                        .Select(nameof(DbTables.Entities.T_HAZIRMETIN.TID), nameof(DbTables.Entities.T_HAZIRMETIN.TANAHTAR));

            var data =q.GetAsync<DbTables.Entities.T_HAZIRMETIN>();
            dgData.DataSource = data.Result.ToList();

How can we use T_HAZIRMETIN table name and column name in QueryBuilder. without using nameof.

ahmad-moussawi commented 2 years ago

@mummyildiz sorry but didn't get the issue here, I think Stackoverflow is better for such questions. I will close this now, feel free to comment for further details.