示例#1
0
        public IList<string> GetTags()
        {
            const string sql = @"
            SELECT DISTINCT
            Category
            FROM    dbo.VideoClips
            ORDER BY Category";

            var result = new List<string>();
            var table = new DbDao().ExecuteSqlDataReader(_connectionString, sql, dr =>
            {
                result.Add(dr.GetString(0));
            });

            return result;
        }
示例#2
0
 public InsertMethod(DbDao dbDao)
 {
     this._dbDao = dbDao;
     this._dictionary = new Dictionary<string, string>();
 }
示例#3
0
 public DeleteMethod(DbDao dbDao)
 {
     this._dbDao = dbDao;
     this._list = new List<string>();
     this._nullValue = new NullValue();
 }
示例#4
0
 public UpdateMethod(DbDao dbDao)
 {
     this._dbDao = dbDao;
     this._list = new List<string>();
 }