Пример #1
0
 public static List<ManageUserListDto> BuildRoles(this List<ManageUserListDto> dtos, MvcSolutionDataContext db)
 {
     var ids = dtos.Select(x => x.Id).ToArray();
     var query = from a in db.UserRoleRls
         let r = a.Role
         where ids.Contains(a.UserId)
         select new
         {
             a.UserId,
             r.Name
         };
     var roles = query.ToList();
     foreach (var dto in dtos)
     {
         dto.Roles = roles.Where(x => x.UserId == dto.Id).Select(x => x.Name).ToArray();
     }
     return dtos;
 }
Пример #2
0
        private void RecreateDatabase()
        {
            var context = new MvcSolutionDataContext();
            var sql =
                @"
            USE MASTER
            DECLARE @i INT
            SELECT   @i=1
            DECLARE @sSPID VARCHAR(100)
            DECLARE KILL_CUR SCROLL CURSOR FOR
            SELECT SPID FROM sysprocesses WHERE DBID=DB_ID('MvcSolution')
            OPEN KILL_CUR
            IF @@CURSOR_ROWS=0 GOTO END_KILL_CUR
            FETCH FIRST FROM KILL_CUR INTO @sSPID
            EXEC('KILL   '+@sSPID)
            WHILE @i<@@CURSOR_ROWS
            BEGIN
            FETCH NEXT FROM KILL_CUR INTO @sSPID
            EXEC('KILL '+@sSPID)
            SELECT @i=@i+1
            END
            END_KILL_CUR:
            CLOSE KILL_CUR
            DEALLOCATE KILL_CUR";
            if (context.Database.Exists())
            {
                try
                {
                    context.Database.ExecuteSqlCommand(sql);
                }
                catch (Exception)
                {
                }
            }
            context.Database.Delete();
            context.Database.Create();

            var connection = new SqlConnection(this.ConnectionString);
            connection.Open();

            var contextType = typeof(MvcSolutionDataContext);
            var excludedTables = new string[] { };
            var additionTables = new string[] { };
            var tables = contextType.GetProperties()
                .Where(x => x.PropertyType.Name == "DbSet`1" && x.CanWrite)
                .Select(p => p.Name)
                .ToList();
            tables.RemoveAll(excludedTables.Contains);
            tables.AddRange(additionTables);

            var ds = new DataSet("MvcSolutionSchema");
            ds.Namespace = "http://tempuri.org/MvcSolutionSchema.xsd";
            ds.ExtendedProperties.Add("targetNamespace", ds.Namespace);
            foreach (var table in tables)
            {
                var adapter = new SqlDataAdapter("select * from " + table, connection);
                adapter.FillSchema(ds, SchemaType.Mapped, table);
            }
            ds.WriteXmlSchema("../../MvcSolutionSchema.xsd");
            connection.Close();
        }