GetSourceData

Given a connection string code, schema and table name e.g. dbo.myTable returns a DataTable copy of the table or view.

Task<DataTable> GetSourceData(string connectionStringCode, string schema, string name);

Parameters

connectionStringCode: The Code of the Connection String as defined in the Bragi UI
schema: Schema e.g. "dbo"
name: Table or view name e.g. "myTable"

Examples

The below example retrieves bus maintenance data from dbo.bus_maintenance_log in the database represented by BusDatabaseCode. It then loops over the rows, extracting the Id and LastMaintenanceDate fields, performs some calculations and returns only certain results in a separate table.

    var busMaintenanceLog = await bragiCodeUtil.GetSourceData("BusDatabaseCode", "dbo", "bus_maintenance_log");

    var busesForMaintenance = new DataTable("dbo.buses_for_maintenance");
    busesForMaintenance.Columns.Add("Id", typeof(int));
    busesForMaintenance.Columns.Add("LastMaintenanceDate", typeof(DateTime));
    
    foreach (var busMaintenanceRow in busMaintenanceLog.AsEnumerable())
    {
        var busId = (int)busMaintenanceRow["Id"];
        var lastMaintenanceDate = (DateTime)busMaintenanceRow["LastMaintenanceDate"];
        if ((DateTime.Now - lastMaintenanceDate).Days > 100)
        {
            busesForMaintenance.Rows.Add(busId, lastMaintenanceDate);
        }
    }

    return new BragiCodeResult(BragiCodeResultCode.Success, busesForMaintenance);

15 September 2025