MspDbSettings

MspDbSettings class

Allows to set necessary options to read project data from MS Project Server database.

public class MspDbSettings : DbSettings

Constructors

NameDescription
MspDbSettings(string, Guid)Initializes a new instance of the MspDbSettings class.

Properties

NameDescription
ConnectionString { get; set; }Gets or sets the connection string.
ProjectGuid { get; }Gets the guid of the project to read.
ProviderInvariantName { get; set; }Gets or sets provider invariant name which is used to get an instance of the DbProviderFactory class. Default value is SqlClient.
Schema { get; set; }Gets or sets the schema of the MS Project Server. The default value is “pub”.

Examples

Shows how to import a project from a database.

try
{
    // Create connection string
    var connectionString = new SqlConnectionStringBuilder();
    connectionString.DataSource = "192.168.56.2,1433";
    connectionString.Encrypt = true;
    connectionString.TrustServerCertificate = true;
    connectionString.InitialCatalog = "ProjectServer_Published";
    connectionString.NetworkLibrary = "DBMSSOCN";
    connectionString.UserID = "sa";
    connectionString.Password = "*****";

    // create settings to load from MS database
    var settings = new MspDbSettings(connectionString.ConnectionString, new Guid("E6426C44-D6CB-4B9C-AF16-48910ACE0F54"));
    settings.Schema = "dbo";

    Console.WriteLine("Project GUID to load: " + settings.ProjectGuid);

    var project = new Project(settings);

    project.Save(OutDir + "ImportProjectDataFromDatabase_out.mpp", SaveFileFormat.Mpp);
}
catch (Exception ex)
{
    Console.WriteLine(ex.Message + " Please setup proper data source (DataSource, InitialCatalog etc)");
}

See Also