C# (CSharp) Menshen.Backend.Services SqliteAppDb.GetDbConnection示例

示例#1

        public string GetValue(string key)
        {
            key = key.ToLowerInvariant().Trim();
            return(_memoryCache.GetOrCreate(key, _ =>
            {
                using var conn = _db.GetDbConnection();
                conn.Open();
                var result = conn.ExecuteScalar <string>(@"
SELECT m_value FROM META_INFO WHERE m_key = @Key;
", new { Key = key });
                conn.Close();
                return result;
            }));
        }

示例#2

        public List <(int, string)> GetSiteContent(string host, int type)
        {
            using var conn = _db.GetDbConnection();
            conn.Open();
            var list = conn.Query <(int, string)>(@"SELECT id, content FROM SITES WHERE host=@host AND type=@type", new { host, type }).ToList();

            return(list);
        }