I am using LLBL Pro in an offline application(without SQL server connection) the schema is each customers have several OverseasNetworks. So the generated XML file is like:

<Entity CustId="Customer1" Assembly="..." Type="DAL.EntityClasses.CustomerEntity"> ....... <EntityCollectionReference PropertyName="OverseasNetwork"> <OverseasNetwork Assembly="" Type=""> <Entities> <Entity Id="115..

    ......
</OverseasNetwork>
  </EntityCollectionReference>

</Entity>

When I read the xml using readXML method, exception is thrown because there is no database connection. But if I delete these keypersonnel nodes in the xml, the reading is ok.

How can I avoid this database connection? because all the data of keypersonnel are inside of the xml file. so I think it should have a way to avoid database connection, right? .

Thanks in advance

I'll look into it, there shouldn't be a database call when calling ReadXml().

I've tried this: StreamReader reader = new StreamReader("chopsFilled.xml"); MyCustomerEntity customerChopsFromXml = new MyCustomerEntity(); string xml= reader.ReadToEnd(); reader.Close(); customerChopsFromXml.ReadXml(xml);

and it works ok, I've altered the connection string to make connection with a bogus machine, and no problems arised, no delays no errors.

PS: this is adapter. I'll now test selfservicing.

With selfservicing I get indeed a timeout error when a collection is restored. I think lazy loading is entered, while this shouldn't be the case. I'll look into it.

Found it. The templates do not check for base.Deserializing == true. This means that a fetch of the entities is performed, while this is unnecessary because the collection will be restored through deserialization.

Will fix this.

Thread moved to Bugs/issues.

The hotfix for this is now available in the form of a template set update. See the template sets section in the customer area.

Otis wrote:

The hotfix for this is now available in the form of a template set update. See the template sets section in the customer area.

Thank you so much for the quick action. I think I bought good product and service.

If you run into problems with the fixed templates, please let me know

Otis wrote:

If you run into problems with the fixed templates, please let me know

Everything is working well, except that the propety of obj: EntityFactoryToUse

if there is a node in XML like this: <EntityFactoryToUse Assembly = Unknown" the a error message will pop up when read this xml file offline, saying the obj is not a instance in the entity2collection method( I forget the exact method. maybe not this one).

Currently what i did is to remove this node in xml before saving it to disk.

hope you can take a look at it.

That means that the entityfactory is null. I'll check it out.

I can't reproduce it here.

I tested the following: (all selfservicing) - an OrderCollection with solely Order objects. Written to XML to disk, read back in a new OrderCollection. Worked - same as above, but now I set EntityFactoryToUse to null before I generated the XML. It gave the same tags as you had, worked. - a Customer entity with Orders collection filled. Written to XML and back, worked.

I'm curious to know what you do exactly when you fetch the objects and write them to XML. Is it a single entity, or a collection? (important), do you set any properties to null before you save it to XML?

Otis wrote:

I can't reproduce it here.

I tested the following: (all selfservicing) - an OrderCollection with solely Order objects. Written to XML to disk, read back in a new OrderCollection. Worked - same as above, but now I set EntityFactoryToUse to null before I generated the XML. It gave the same tags as you had, worked. - a Customer entity with Orders collection filled. Written to XML and back, worked.

I'm curious to know what you do exactly when you fetch the objects and write them to XML. Is it a single entity, or a collection? (important), do you set any properties to null before you save it to XML?

it is a collection of customer, which has a collection of networks. First I write xml of the customer collection online, the EntityFactoryToUse will be filled by value. then I read xml of customer collection offline and save it offline. EntityFactoryToUse will have unknow value. then next time I read xml of customer collection offline. the error msg comes.

The problem resides on saving the customer offline, which don't have the value of EntityFactoryToUse.

I wonder why the entityfactorytouse is suddenly null, as the class is part of the generated code. So when you read the XML offline, you should have the entity factory class available, so when you then again write it offline, EntityFactoryToUse should have a value, not null... could you check for me if the EntityFactoryToUse property is null AFTER you've read the XML offline?

Otis wrote:

I wonder why the entityfactorytouse is suddenly null, as the class is part of the generated code. So when you read the XML offline, you should have the entity factory class available, so when you then again write it offline, EntityFactoryToUse should have a value, not null... could you check for me if the EntityFactoryToUse property is null AFTER you've read the XML offline?

Hi Otis, When first I generate it online, EntityFactoryToUse is filled with value. but when I read it offline, and store them back offline, EntityFactoryToUse becomes null. I tried this. so I have to remove all the EntityFactoryToUse nodes when I store xml offline.

WMS wrote:

Otis wrote:

I wonder why the entityfactorytouse is suddenly null, as the class is part of the generated code. So when you read the XML offline, you should have the entity factory class available, so when you then again write it offline, EntityFactoryToUse should have a value, not null... could you check for me if the EntityFactoryToUse property is null AFTER you've read the XML offline?

Hi Otis, When first I generate it online, EntityFactoryToUse is filled with value. but when I read it offline, and store them back offline, EntityFactoryToUse becomes null. I tried this. so I have to remove all the EntityFactoryToUse nodes when I store xml offline.

The thing in italics should not happen. I'll check it out if I can reproduce it here...

I can't reproduce this.

What I did was this:

public void SerializationTest()
{
    StreamWriter writer = new StreamWriter("customer.xml");
    CustomerEntity customer = new CustomerEntity("BLONP");
    OrderCollection orders = customer.Orders;
    string xml = string.Empty;
    customer.WriteXml(out xml);
    writer.Write(xml);
    writer.Close();
}

public void DeserializationTest()
{
    StreamReader reader = new StreamReader("customer.xml");
    string customerXml = reader.ReadToEnd();
    CustomerEntity customerFromXml = new CustomerEntity();
    customerFromXml.ReadXml(customerXml);
    reader.Close();

    // write it back to a different file.
    StreamWriter writer = new StreamWriter("customer2.xml");
    string xml = string.Empty;
    customerFromXml.WriteXml(out xml);
    writer.Write(xml);
    writer.Close();
}

//...
// call the 2 testroutines:
tester.SerializationTest();
tester.DeserializationTest();

Checking both xml files, I can only conclude that they all contain the right xml and load correctly.

Even if I make the entityfactorytouse null, it works. So I have the feeling the code on client and server aren't in sync with eachother: you use an older version of runtimes and/or generated code on client or server than the other process (so newer on server, older on client or vice versa). Could you check that for me, please?

Issue was re-opened and a fix to the ReadXml method is now available in a hotfix for the runtime libraries. Could you please test if this fix is also fixing your problem?