Example #1
0
        private List <IDbEntity> GetAllViews(DbSchema schema, IDbConnection conn = null)
        {
            List <IDbEntity> views;

            using (var con = conn ?? GetConnection())
            {
                views = con.Query <DbEntity>(SqlStatements.GetAllViews(_dbType), new { DbName = con.Database, Schema = schema.SchemaName }).ToList <IDbEntity>();
            }
            foreach (var dbEntity in views)
            {
                dbEntity.IsView = true;
            }
            return(views);
        }