Symbiotic ORM Parallel Load

ParallelLoadItems.cs

    public void ParallelLoadItems()
    {
        IDatabaseTypesFactory factory = new DatabaseTypesFactorySqlServer();
        factory.ConnectionString = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=D:\\Dev\\FrozenElephant\\SymbioticORM\\SqlDatabase\\SymbioticTestLocal.mdf;Integrated Security=True;Connect Timeout=30";
        IObjectLoader loader = factory.CreateObjectLoader();    

        IList<ISqlQuery> queries = new List<ISqlQuery>();
        ISqlQuery s1 =  factory.CreateSqlQuery("Select top 2000 * from People","ParallelLoadItems:Person", typeof(Person));
        queries.Add(s1);

        ISqlQuery e1 = factory.CreateSqlQuery("Select * from Errors","ParallelLoadItems:ErrorItem", typeof(ErrorItem));
        queries.Add(e1);

        ISqlQuery a1 = factory.CreateSqlQuery("Select * from addresses","ParallelLoadItems:Address", typeof(Address));
        queries.Add(a1);

        ISqlQuery p1 = factory.CreateSqlQuery("Select * from PhoneNumbers","ParallelLoadItems:PhoneNumber", typeof(PhoneNumber));
        queries.Add(p1);

        IList<IList> data = loader.ParallelLoadItems(queries);

        IList<Address> addresses = (IList<Address>)data[2];
        addresses[2].CityName = "Home";

        if (data.Count == 0)
        {
            Assert.Fail();
        }
    }

The parameters of "ParallelLoadItems:* are just a debugging aid. The text will be included in any error message to help the developer isolate the problem query.

Also the return collection's results order will be in the same order as queried regardless of completion time of each query. So first collection will be of Person, then ErrorItem, and so on...