C# (CSharp) System.Data.SQLite.SQLiteConnection.GetList Examples

Example #1

File: DBManager.cs Project: Kanna-mimimin/ObsBrowserYouTubeLoginTool

        public static IEnumerable <cookies> GetYoutubeCookies(string srcCookieFilePath, string host_key)
        {
            DapperExtensions.DapperExtensions.SqlDialect    = new DapperExtensions.Sql.SqliteDialect();
            DapperExtensions.DapperExtensions.DefaultMapper = typeof(cookiesClassMapper <>);

            using (var cn = new System.Data.SQLite.SQLiteConnection("Data Source=" + srcCookieFilePath))
            {
                cn.Open();
                var predicate = Predicates.Field <cookies>(f => f.host_key, Operator.Eq, host_key);
                var list      = cn.GetList <cookies>(predicate).ToArray();
                return(list);
            }
        }