//Load all drawings from DB to list of Drawing objects
        public static List <Drawing> LoadAllDrawings()
        {
            SqlBuilder builder = new Dapper.SqlBuilder();

            SqlBuilder.Template select = builder.AddTemplate("SELECT * FROM Drawings");

            return(QueryDatabase(select));
        }
Example #2
0
        public Task <IEnumerable <Demo> > DemoListByWhere(int obj)
        {
            Dapper.SqlBuilder builder = new Dapper.SqlBuilder();
            var query    = $@"select * from {typeof(Demo).Name} /**where**/ /**orderby**/ ";
            var template = builder.AddTemplate(query);

            builder.Where("Age=@a", new { a = obj });
            builder.OrderBy("Id");
            using (Db.Connection)
            {
                var data = this.Db.Connection.QueryAsync <Demo>(template.RawSql, template.Parameters);
                return(data);
            }
        }
        //Load from filter using Dapper.SQLBuilder to combine where clauses
        public static List <Drawing> LoadDrawings(string filter, string starts, string group)
        {
            SqlBuilder builder = new Dapper.SqlBuilder();

            SqlBuilder.Template select = builder.AddTemplate("SELECT * FROM Drawings /**where**/");

            if (!string.IsNullOrEmpty(filter))
            {
                builder.Where($"\"File\" like '{starts}{filter}%'");
            }
            if (!string.IsNullOrEmpty(group))
            {
                builder.Where($"\"Group\" like '{group}'");
            }

            Log.Write.Info(select.RawSql.TrimEnd());

            return(QueryDatabase(select));
        }