MspDbSettings class

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

public class MspDbSettings : DbSettings


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


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”.


Shows how to import a project from a database.

    // Create connection string
    var connectionString = new SqlConnectionStringBuilder();
    connectionString.DataSource = ",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