通过AMO获取SQL Server SSAS信息代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】通过AMO获取SQL Server SSAS信息

作者:zjq2008wd / 发布于2014/4/11/ 487

通过AMO获取SQL Server SSAS信息（C#）

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using Microsoft.AnalysisServices;

namespace AMOTest
{
  class Program
  {

    static void Main(string[] args)
    {

      string ConnecteString = "Data Source =ServerName; Provider=msolap";
      Server SSASServer = new Server();
      SSASServer.Connect(ConnecteString);

      List<Database> OutDatabase = GetDatabaseCollection(SSASServer);


      //show all database on the server
      Console.WriteLine("-------------Databse-------------------------------");
      for (int i = 0; i < OutDatabase.Count; i++)
      {
        Console.WriteLine(OutDatabase[i].Name.ToString());
      }
     

      //show the Cube of a database
      Console.WriteLine("---------------Cube--------------------------------");
      List<Cube> OutCube = GetCubeCollection(OutDatabase[0]);
      for (int i = 0; i < OutCube.Count; i++)
      {
        Console.WriteLine(OutCube[i].Name.ToString());
      }
     

      //show all Roles of one database
      Console.WriteLine("---------------Roles_database-------------------------");
      List<Role> OutRole = GetRolescollection(OutDatabase[0]);

      Console.WriteLine(OutRole[0].Members.Count);


      //for (int i = 0; i < OutRole[0].Members.Count; i++)       //to show the detial of the role Members
      //{
      //  Console.WriteLine(OutRole[0].Members[i].Name);
      //}


        //show all Roles of one cube
      Console.WriteLine("---------------Roles_Cube----------------------------");
      List<Role> OutRole2 = GetRolescollection2(OutCube[0]);
      Console.WriteLine(OutRole2[0].Members.Count);

      //for (int i = 0; i < OutRole2[0].Members.Count; i++)
      //{
      //  Console.WriteLine(OutRole2[0].Members[i].Name);     //to show the detial of the role Members
      //}


        Console.Read();
    }



    //get the list of the database name
    static public List<Database> GetDatabaseCollection(Server server)
    {
      List<Database> collectdb = new List<Database>();
      foreach (Database db in server.Databases)
      {
        collectdb.Add(db);
      }
      return collectdb;
    }

    //get the list of a database cube name
    static public List<Cube> GetCubeCollection(Database db)
    {
      List<Cube> collectcube = new List<Cube>();
      foreach (Cube cube in db.Cubes)
      {
        collectcube.Add(cube);
      }
      return collectcube;
    }

    //get the list of the database roles
    static public List<Role> GetRolescollection(Database db)
    {
      List<Role> collectRoles = new List<Role>();
      foreach (Role cp in db.Roles)
      {
        collectRoles.Add(cp);
      }
      return collectRoles;
    }
    //get the list of the cube Roles
    static public List<Role> GetRolescollection2(Cube cube)
    {
      List<Role> collectionRoles = new List<Role>();
      foreach (CubePermission cp in cube.CubePermissions)
      {
        collectionRoles.Add(cp.Role);
      }
      return collectionRoles;
    }
  }
}

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　SSAS　

同语言下

可能有用的

zjq2008wd贡献的其它代码(4)