public GetConnections ( Server server, Microsoft database ) : |
||
server | Server | |
database | Microsoft | |
리턴 |
public Connections GetConnections( Server server, Microsoft.SqlServer.Management.Smo.Database database )
{
var sqlConnection = new Connection
{
Name = "DbConnection",
ConnectionString =
string.Format( "Server={0};Initial Catalog={1};Integrated Security=SSPI;", server.Name, database.Name )
};
return new Connections
{
Connection = sqlConnection
};
}
public static Biml BuildBiml( BimlRequest request ) { // Configure SQL SMO var server = new Server( request.ServerName ); var scriptingOptions = new ScriptingOptions { Encoding = Encoding.UTF8 }; server.Script( scriptingOptions ); var database = new Microsoft.SqlServer.Management.Smo.Database( server, request.DatabaseName ); database.Refresh(); var bimlService = new BimlService(); var output = new Biml(); // Selectively build sections if ( request.HasConnections ) output.Connections = bimlService.GetConnections( server, database ); if ( request.HasDatabases ) output.Databases = bimlService.GetDatabases( database ); if( request.HasSchemas ) output.Schemas = bimlService.GetSchemas( database ); if (request.HasTables) { output.Tables = bimlService.GetTables( database, request.HasFactsAndDimensions ); } if (request.HasFactsAndDimensions) { output.Facts = bimlService.GetFacts( database ); output.Dimensions = bimlService.GetDimensions( database ); } return output; }