LinqPad - Helmut-Ortmann/EnterpriseArchitect_hoTools GitHub Wiki

// Requirement summary:
// - Type
// - Count
// - Percentage
// - Total count of requirements
var countReq = t_object.Where(e => e.Object_Type == "Requirement").Count();
var query =
                        (from c in t_object.AsEnumerable()
                         where c.Object_Type == "Requirement"
                         group c by c.Stereotype into g
                         orderby g.Key

                         select new
                         {
                             Type = (g.Key == null) ? "Simple" : $"<<{g.Key}>>",
                             Prozent = $"{ (float)g.Count() * 100 / countReq:00.00}%",
                             Count = g.Count(),
                             Total = countReq
                         });
query.Dump("EAExample JET, SqlServer, MySQL,..");

void Main(string[] args)
{
	// process id
	int pid = 0;
	//
	// Use CMD symbol to check whether you're running in the GUI or from the command line, you can do this as follow
	// see: https://www.linqpad.net/lprun.aspx
#if CMD
        // run from command line via lprun
		if (args != null && args.Length > 0)
		{
			pid = Int32.Parse(args[0]);
			"_".Dump($"Run by Batch for process '{pid}'");
		}
#else
	// run in LINQPad GUI
	"_".Dump("Run by Dialog");
    // Get PID of EA
	Process processEa = Process.GetProcessesByName("EA").FirstOrDefault();
	if (processEa == null)
	{
		MessageBox.Show("","Can't determine running ea.exe instance!");
		return;
	}
	pid = processEa.Id.Dump("ProcessID");
	
#endif
	// run for found EA instance
	if (pid > 0)
	{
		Program p = new Program(pid);
		EA.Repository rep = p.Repository;
		rep.ConnectionString.Dump();
	}
}
//---------------------------------------------------------
// Get the Repository from the program ID
//---------------------------------------------------------
// This method is used to call this script from EA and access the Repository the call comes from
//
class Program
{
	private EA.Repository _repository = null;
	private int m_ProcessID = 0;
	// get the EA repository from the progid
	public Program(int pid)
	{
		m_ProcessID = pid;
		_repository = SparxSystems.Services.GetRepository(m_ProcessID);
		Trace("Running C# Console Application AppPattern .NET 4.0");
	}
	public EA.Repository Repository
	{
		get { return _repository;}
	}
	public void Trace(string msg)
	{
		if (_repository != null)
		{
			// Displays the message in the 'Script' tab of Enterprise Architect System Output Window
			_repository.WriteOutput("Script", msg, 0);
		}
		Console.WriteLine(msg);
	}
}

void Main()
{
	//----------------------------------------------------------------------------------------------
	// EaAutomationTemplate
	//----------------------------------------------------------------------------------------------
	//
	// Template to access EA with two strategies:
	// - LINQ to DB
	// - Native access to an EA Repository and access via COM and EA API (Interop.EA.dll)
	//   - opening *.eap file 
	string provider = "Access";
	// see: http://sparxsystems.com/enterprise_architect_user_guide/14.0/automation/repository3.html
	// Repository.OpenFile();
	// - path to *.eap(x) file, might be a shortcut to a DBMS/SQL Database
	// - connections string
	string repositoryPath = @"c:\Users\helmu\AppData\Roaming\Sparx Systems\EA\EAExample.eap";// Example database
	
	// Access to Repository
	EA.Repository rep = new EA.Repository();
	rep.OpenFile(repositoryPath);
	
	rep.ConnectionString.Dump();

	// Use LINQ to SQL
	// Use connection to SPARX Example Database
	string newConnectionString = ConstructConnectionString(Connection.ConnectionString, repositoryPath);
	using (TypedDataContext db = new TypedDataContext(provider, newConnectionString))
	{
		var rootPackages = from pkg in db.t_package
						   where pkg.Parent_ID == 0
						   orderby pkg.Name
						   select new { Name=pkg.Name, Package =pkg.Ea_guid};
		rootPackages.Dump();
	}

}

// Define other methods and classes here

// ------------------------------------------------------------------------------------------------------------------
// ConstructConnectionString
// ------------------------------------------------------------------------------------------------------------------
// Construct the connection string from datasource. This you can use to make a connection to the wanted connection by:
// - TypedDataContext db = new TypedDataContext("SQLite", newConnectionString);
// - TypedDataContext db = new TypedDataContext("Access", newConnectionString);
//
// Note: You uses the definitions of the used LINQPad connection
//
public string ConstructConnectionString(string oldConnection, string dataSource)
{
	Regex rx = new Regex(@"Data Source=[^;]*;");
	return rx.Replace(oldConnection, $"Data Source={dataSource};");

}

// Process in memory to avoid SQL Access (e.g. string.Join(", ", isn't supported by Access SQL)
var tempRead = read.ToList().AsEnumerable();                 //.Dump("Read in memory");
var tempWrite = write.ToList().AsEnumerable();               //.Dump("Write in memory");;
var combined = tempRead.Concat(tempWrite).AsEnumerable();    //.Dump("Combined in memory");