HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data.SQLite;

using ID2.Manager.Data.Models;

namespace ID2.Manager.Dapper.Repository

{

    public class ID2Repository : BaseRepository

    {

        public ID2Repository(string connectionStr, DatabaseType databaseType) : base(connectionStr, databaseType) { }

        public IEnumerable<ID2ProjectInfo> GetID2ProjectList()

        {

            string query = $@"

SELECT * FROM Projects WHERE ifnull(Name, '') <> '' ORDER BY Id";

            return Query<ID2ProjectInfo>(query);

        }

    }

}