Class DatabaseInfo
- Inheritance
-
DatabaseInfo
- Inherited Members
- Namespace
- TabularEditor.TOMWrapper
- Assembly
- TOMWrapper.dll
Lightweight, read-only snapshot of a database on an Analysis Services / Power BI server, sourced from the DBSCHEMA_CATALOGS DMV. Use this instead of enumerating Microsoft.AnalysisServices.Tabular.Server.Databases when you only need name/ID/CL/modified-date, since the TOM enumeration causes models to be swapped into memory on the server.
public class DatabaseInfo- Extension Methods
Constructors
DatabaseInfo()
public DatabaseInfo()Properties
CompatibilityLevel
Compatibility level of the database (COMPATIBILITY_LEVEL).
public int CompatibilityLevel { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Description
Database description (DESCRIPTION). Null when not requested, empty string when set but empty.
public string Description { get; set; }Property Value
| Type | Description |
|---|---|
| string |
ID
Server-assigned database identifier (DATABASE_ID).
public string ID { get; set; }Property Value
| Type | Description |
|---|---|
| string |
LastUpdate
UTC timestamp of the last metadata modification (DATE_MODIFIED). Null when not requested.
public DateTime? LastUpdate { get; set; }Property Value
| Type | Description |
|---|---|
| DateTime? |
Name
Database (catalog) display name (CATALOG_NAME).
public string Name { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Methods
GetDatabasesFromServer(Server)
Returns the list of databases on the server by querying the DBSCHEMA_CATALOGS DMV. Unlike enumerating Microsoft.AnalysisServices.Tabular.Server.Databases, this does not cause models to be swapped into memory on the server (critical for the Power BI service, which may evict other models to honor the implicit load).
public static List<DatabaseInfo> GetDatabasesFromServer(Server server)Parameters
| Type | Name | Description |
|---|---|---|
| Server | server |
Returns
| Type | Description |
|---|---|
| List<DatabaseInfo> |