public static void Run()
{
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName);
try
{
// ExStart:SupportForSQLiteDatabase
string connectionString = "Data Source=" + dataDir + "\\PPMDBSQLite.db";
const int projectId = 4502;
// Create Primavera DB Settings using connection string and project id
PrimaveraDbSettings primaveraDbSettings = new PrimaveraDbSettings(connectionString, projectId);
primaveraDbSettings.ProviderInvariantName = "System.Data.SQLite";
// Create new project using primavera db settings
Project project = new Project(primaveraDbSettings);
// ExEnd:SupportForSQLiteDatabase
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + "\nPlease setup proper datasource (connectionString, ProviderInvariantName) etc");
}
}
public void ImportProjectFromPrimaveraDBSQLite()
{
try
{
// ExStart:ImportProjectFromPrimaveraDBSQLite
// ExFor: DbSettings
// ExFor: DbSettings.#ctor(String)
// ExFor: DbSettings.ConnectionString
// ExFor: DbSettings.ProviderInvariantName
// ExSummary: Shows how to read a project from a Primavera XML file with multiple projects by using a provider name.
var connectionString = "Data Source=" + DataDir + "\\PPMDBSQLite.db";
// Create Primavera DB Settings using connection string and project id
var settings = new PrimaveraDbSettings(connectionString, 4502);
settings.ProviderInvariantName = "System.Data.SQLite";
Console.WriteLine("Connection String: " + settings.ConnectionString);
Console.WriteLine("Provider Name: " + settings.ProviderInvariantName);
var project = new Project(settings);
project.Save(OutDir + "SupportForSQLiteDatabase_out.mpp", SaveFileFormat.MPP);
// ExEnd:ImportProjectFromPrimaveraDBSQLite
}
catch (ArgumentException ex)
{
Console.WriteLine(ex.Message + "\nPlease setup proper data source (connectionString, ProviderInvariantName) etc");
}
catch (TasksReadingException ex)
{
Console.WriteLine(ex.Message + "\nPlease setup proper data source (connectionString, ProviderInvariantName) etc");
}
}
public static void Run()
{
// ExStart:ImportProjectFromPrimaveraDB
SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder();
sb.DataSource = "192.168.56.3,1433";
sb.Encrypt = true;
sb.TrustServerCertificate = true;
sb.InitialCatalog = "PrimaveraEDB";
sb.NetworkLibrary = "DBMSSOCN";
sb.UserID = "privuser";
sb.Password = "******";
// Initialize a new instance of the PrimaveraDbSettings class with connection string and project id
PrimaveraDbSettings settings = new PrimaveraDbSettings(sb.ConnectionString, 4502);
// Initialize a new instance of the Project class
Project project = new Project(settings);
// ExEnd:ImportProjectFromPrimaveraDB
}
public static void Run()
{
// ExStart:SupportForSQLiteDatabase
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir_PrintingAndExporting();
try
{
const string connectionString = "SQLiteDatabaseConnectionString";
const int projectId = 4502;
PrimaveraDbSettings primaveraDbSettings = new PrimaveraDbSettings(connectionString, projectId);
primaveraDbSettings.ProviderInvariantName = "System.Data.SQLite";
Project project = new Project(primaveraDbSettings);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + "\nPlease setup proper datasource (connectionString, ProviderInvariantName) etc");
}
// ExEnd:SupportForSQLiteDatabase
}
public static void Run()
{
// ExStart:ImportProjectFromPrimaveraDB
SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder();
sb.DataSource = "192.168.56.3,1433";
sb.Encrypt = true;
sb.TrustServerCertificate = true;
sb.InitialCatalog = "PrimaveraEDB";
sb.NetworkLibrary = "DBMSSOCN";
sb.UserID = "privuser";
sb.Password = "******";
// Initialize a new instance of the PrimaveraDbSettings class with connection string and project id
PrimaveraDbSettings settings = new PrimaveraDbSettings(sb.ConnectionString, 4502);
// Initialize a new instance of the Project class
Project project = new Project(settings);
// ExEnd:ImportProjectFromPrimaveraDB
}
public void ImportProjectFromPrimaveraDB()
{
try
{
// ExStart:ImportProjectFromPrimaveraDB
// ExFor: PrimaveraDbSettings
// ExFor: PrimaveraDbSettings.#ctor(String,Int32)
// ExFor: PrimaveraDbSettings.ProjectId
// ExSummary: Shows how to import a project from a Primavera database.
var sb = new SqlConnectionStringBuilder();
sb.DataSource = "192.168.56.3,1433";
sb.Encrypt = true;
sb.TrustServerCertificate = true;
sb.InitialCatalog = "PrimaveraEDB";
sb.NetworkLibrary = "DBMSSOCN";
sb.UserID = "privuser";
sb.Password = "******";
sb.ConnectTimeout = 2; // ExSkip
// Initialize a new instance of the PrimaveraDbSettings class with connection string and project id
var settings = new PrimaveraDbSettings(sb.ConnectionString, 4502);
Console.WriteLine("Project UID to read: " + settings.ProjectId);
// read the project with UID = 4502
var project = new Project(settings);
Console.WriteLine(project.Get(Prj.Uid));
// ExEnd:ImportProjectFromPrimaveraDB
}
catch (NotSupportedException ex)
{
Console.WriteLine(ex.Message + "\nPlease setup proper data source (connectionString, ProviderInvariantName) etc");
}
catch (TasksReadingException ex)
{
Console.WriteLine(ex.Message);
}
}
public static void Run()
{
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName);
try
{
//ExStart:SupportForSQLiteDatabase
string connectionString = "Data Source=" + dataDir + "\\PPMDBSQLite.db";
const int ProjectId = 4502;
// Create Primavera DB Settings using connection string and project id
PrimaveraDbSettings primaveraDbSettings = new PrimaveraDbSettings(connectionString, ProjectId);
primaveraDbSettings.ProviderInvariantName = "System.Data.SQLite";
// Create new project using primavera db settings
Project project = new Project(primaveraDbSettings);
//ExEnd:SupportForSQLiteDatabase
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + "\nPlease setup proper data source (connectionString, ProviderInvariantName) etc");
}
}
