How to parse an ACORD XML which can have muliple Transactions in it

I need to parse an ACORD xml which can contain mutiple transactions in it and update SQL Transaction tables with the each transaction.

I have not handled ACORD XML with mutiple transactions till now. Could you please suggest different approaches to do this (in C#)?
Kiran_MAsked:
Who is Participating?
 
McExpConnect With a Mentor Commented:
Could you post an example of the specific acord file you are looking to parse?
0
 
McExpCommented:
I would load the XML file into an XML document. Write an appropriate XPath statement which extracts each transaction node and then "foreach" node make a UPDATE query against the database.
0
 
anarki_jimbelCommented:
I am not sure if many people know how to do this. ACORD is quite a new standard.
Some companies products have support for ACORD XML, however this is not free, e.g
see INGENIUM .NET:

http://www.solcorp.com/products/net.htm

I don't really know the format and tasks to be solved. However xml is xml, and you may try to write your own library to handle specific ACORD formats. Eventually .Net has excellent support for xml.

0
 
Kiran_MAuthor Commented:
Specifications have changed,Closing this.  

Thanks.
0
 
Kiran_MAuthor Commented:
Specifications changed.  Closing this question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.