How to load XML data to a data structure?

I have the following XML document

"1.0" encoding = "utf-8"?>
"0001" createdon ="11/02/20" expireson="12/02/20">
"A10">
1977
Skyhawk
Light blue and white
New paint, nearly new interior,
685 hours SMOH, full IFR King avionics
23,495
"s001" phone="123-123-123"> Skyway Aircraft
"s002" phone="123-123-222"> Boeing
"s003" phone="123-123-233"> McDouglas
"1000" from="12/03/16" to="12/03/18" no="M0001">Silver
"1000" from="12/03/16" to="12/03/18" no="M0002">Gold
"1000" from="12/03/16" to="12/03/18" no="M0003">Platinum
Rapid City,
South Dakota
"002" createdon ="11/05/20" expireson="12/05/20">
1965
&p;
Cherokee
Gold
240 hours SMOH, dual NAVCOMs, DME,
new Cleveland brakes, great shape
"555-333-2222" email="[email protected]" id="s004">John Seller
"1000" from="12/03/16" to="12/03/18" no="M0020">State Membership
"1000" from="12/03/16" to="12/03/18" no="M0002">Gold
St. Joseph,
Missouri

I have the following C# classes

class Advert2
{
public int? Id { get; set; }
public DateTime? CreatedOn { get; set; }
public DateTime? ExpiresOn { get; set; }
public Aircraft MyAircraft { get; set; }
public List MySellers { get; set; }
public List MyMemberships { get; set; }
public Advert2()
{
MySellers = new List();
MyMemberships = new List();
MyAircraft = new Aircraft();
}
}
class Seller2
{
public int? Id { get; set; }
public string SellerName { get; set; }
public string Phone { get; set; }
}
class Membership
{
public int? Id { get; set; }
public string MembershipNumber { get; set; }
public DateTime? From { get; set; }
public DateTime? To { get; set; }
public String MemberType { get; set; }
}
class Aircraft {
public string Make { get; set; }
public string Model { get; set; }
public decimal? Price { get; set; }
public string Description { get; set; }
}

Then i have used the following two methods to parse XML elements and attributes ( check for NULLs )

public static class XMLCommons
{
public static string TryGetElementValue(this XElement parentEl, string elementName, string defaultValue = null)
{
var foundEl = parentEl.Element(elementName);
if (foundEl != null)
{
return foundEl.Value;
}
return defaultValue;
}
public static string TryGetAttribtueValue(this XElement parentEl, string elementName, string attrName, string defaultValue = null)
{
var foundEl = parentEl.Element(elementName);
if (foundEl != null) {
//check attribute exists
var foundAttr = foundEl.Attribute(attrName);
if (foundAttr != null)
{
return foundAttr.Value;
}
}
return defaultValue;
}
}

Then i have written the following code to read element/attributes on the XML, and populate data to the `Advert2` object structure

var xmlPath2 = System.IO.Path.Combine("../../../data/" + "XMLFile2.xml");
var xml2 = XDocument.Load(xmlPath2);
var query2 = xml2.Root.Descendants("ad").Select(n => new Advert2 {
Id = Convert.ToInt32(n.Parent.TryGetAttribtueValue("ad", "id")),
CreatedOn = Convert.ToDateTime( n.Parent.TryGetAttribtueValue("ad", "createdon") ),
ExpiresOn = Convert.ToDateTime(n.Parent.TryGetAttribtueValue("ad", "expireson")),
MyAircraft = new Aircraft {
Make = n.TryGetElementValue("make"),
Model = n.TryGetElementValue("model"),
Description = n.TryGetElementValue("description"),
Price = Convert.ToDecimal( n.TryGetElementValue("price") ) },
MySellers = new List().Add( new Seller2 {
Id = Convert.ToInt32( n.TryGetAttribtueValue("seller","id") ),
SellerName = n.TryGetElementValue("seller"),
Phone = n.TryGetAttribtueValue("seller","phone")
} )
}).ToList();

but the issues is i get syntax errors when i tried to create objects to populate `MySellers` List.

Error:

Severity Code Description Project File Line Suppression State
Error CS0029 Cannot implicitly convert type 'void' to System.Collections.Generic.List'

So it seems like i don't know how to populate those two collections `MySellers` and `MyMemberships`.

is there away to populate those two collections so i can create the `Averts2` Collection?

Rajanikant Hawaldar5y ago

var xmlStream = new StreamReader(@"D:\something.xml");
var serializer = new XmlSerializer(typeof(flights_for_sale));
var result = (flights_for_sale)serializer.Deserialize(xmlStream);

Below was obtained by pasting the xml into visual studio Edit -> Paste Special -> Paste XML as Classes

// NOTE: Generated code may require at least .NET Framework 4.5 or .NET Core/Standard 2.0.
///
[System.SerializableAttribute()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
[System.Xml.Serialization.XmlRootAttribute(Namespace = "", IsNullable = false)]
public partial class flights_for_sale
{
private flights_for_saleAD[] adField;
///
[System.Xml.Serialization.XmlElementAttribute("ad")]
public flights_for_saleAD[] ad
{
get
{
return this.adField;
}
set
{
this.adField = value;
}
}
}
///
[System.SerializableAttribute()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
public partial class flights_for_saleAD
{
private flights_for_saleADAircraft aircraftField;
private flights_for_saleADSeller[] sellerField;
private flights_for_saleADMembership[] membershipField;
private flights_for_saleADLocation locationField;
private byte idField;
private string createdonField;
private string expiresonField;
///
public flights_for_saleADAircraft aircraft
{
get
{
return this.aircraftField;
}
set
{
this.aircraftField = value;
}
}
///
[System.Xml.Serialization.XmlElementAttribute("seller")]
public flights_for_saleADSeller[] seller
{
get
{
return this.sellerField;
}
set
{
this.sellerField = value;
}
}
///
[System.Xml.Serialization.XmlElementAttribute("membership")]
public flights_for_saleADMembership[] membership
{
get
{
return this.membershipField;
}
set
{
this.membershipField = value;
}
}
///
public flights_for_saleADLocation location
{
get
{
return this.locationField;
}
set
{
this.locationField = value;
}
}
///
[System.Xml.Serialization.XmlAttributeAttribute()]
public byte id
{
get
{
return this.idField;
}
set
{
this.idField = value;
}
}
///
[System.Xml.Serialization.XmlAttributeAttribute()]
public string createdon
{
get
{
return this.createdonField;
}
set
{
this.createdonField = value;
}
}
///
[System.Xml.Serialization.XmlAttributeAttribute()]
public string expireson
{
get
{
return this.expiresonField;
}
set
{
this.expiresonField = value;
}
}
}
///
[System.SerializableAttribute()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
public partial class flights_for_saleADAircraft
{
private ushort yearField;
private string makeField;
private string modelField;
private string colorField;
private string descriptionField;
private string priceField;
private string idField;
///
public ushort year
{
get
{
return this.yearField;
}
set
{
this.yearField = value;
}
}
///
public string make
{
get
{
return this.makeField;
}
set
{
this.makeField = value;
}
}
///
public string model
{
get
{
return this.modelField;
}
set
{
this.modelField = value;
}
}
///
public string color
{
get
{
return this.colorField;
}
set
{
this.colorField = value;
}
}
///
public string description
{
get
{
return this.descriptionField;
}
set
{
this.descriptionField = value;
}
}
///
public string price
{
get
{
return this.priceField;
}
set
{
this.priceField = value;
}
}
///
[System.Xml.Serialization.XmlAttributeAttribute()]
public string id
{
get
{
return this.idField;
}
set
{
this.idField = value;
}
}
}
///
[System.SerializableAttribute()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
public partial class flights_for_saleADSeller
{
private string idField;
private string phoneField;
private string emailField;
private string valueField;
///
[System.Xml.Serialization.XmlAttributeAttribute()]
public string id
{
get
{
return this.idField;
}
set
{
this.idField = value;
}
}
///
[System.Xml.Serialization.XmlAttributeAttribute()]
public string phone
{
get
{
return this.phoneField;
}
set
{
this.phoneField = value;
}
}
///
[System.Xml.Serialization.XmlAttributeAttribute()]
public string email
{
get
{
return this.emailField;
}
set
{
this.emailField = value;
}
}
///
[System.Xml.Serialization.XmlTextAttribute()]
public string Value
{
get
{
return this.valueField;
}
set
{
this.valueField = value;
}
}
}
///
[System.SerializableAttribute()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
public partial class flights_for_saleADMembership
{
private ushort idField;
private string fromField;
private string toField;
private string noField;
private string valueField;
///
[System.Xml.Serialization.XmlAttributeAttribute()]
public ushort id
{
get
{
return this.idField;
}
set
{
this.idField = value;
}
}
///
[System.Xml.Serialization.XmlAttributeAttribute()]
public string from
{
get
{
return this.fromField;
}
set
{
this.fromField = value;
}
}
///
[System.Xml.Serialization.XmlAttributeAttribute()]
public string to
{
get
{
return this.toField;
}
set
{
this.toField = value;
}
}
///
[System.Xml.Serialization.XmlAttributeAttribute()]
public string no
{
get
{
return this.noField;
}
set
{
this.noField = value;
}
}
///
[System.Xml.Serialization.XmlTextAttribute()]
public string Value
{
get
{
return this.valueField;
}
set
{
this.valueField = value;
}
}
}
///
[System.SerializableAttribute()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
public partial class flights_for_saleADLocation
{
private string cityField;
private string stateField;
///
public string city
{
get
{
return this.cityField;
}
set
{
this.cityField = value;
}
}
///
public string state
{
get
{
return this.stateField;
}
set
{
this.stateField = value;
}
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
1. var xmlStream = new StreamReader(@"D:\something.xml");
2. var serializer = new XmlSerializer(typeof(flights_for_sale));
3. var result = (flights_for_sale)serializer.Deserialize(xmlStream);
Below was obtained by pasting the xml into visual studio Edit -> Paste Special -> Paste XML as Classes
1. // NOTE: Generated code may require at least .NET Framework 4.5 or .NET Core/Standard 2.0.
2. ///
3. [System.SerializableAttribute()]
4. [System.ComponentModel.DesignerCategoryAttribute("code")]
5. [System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
6. [System.Xml.Serialization.XmlRootAttribute(Namespace = "", IsNullable = false)]
7. public partial class flights_for_sale
8. {
9. private flights_for_saleAD[] adField;
10. ///
11. [System.Xml.Serialization.XmlElementAttribute("ad")]
12. public flights_for_saleAD[] ad
13. {
14. get
15. {
16. return this.adField;
17. }
18. set
19. {
20. this.adField = value;
21. }
22. }
23. }
24. ///
25. [System.SerializableAttribute()]
26. [System.ComponentModel.DesignerCategoryAttribute("code")]
27. [System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
28. public partial class flights_for_saleAD
29. {
30. private flights_for_saleADAircraft aircraftField;
31. private flights_for_saleADSeller[] sellerField;
32. private flights_for_saleADMembership[] membershipField;
33. private flights_for_saleADLocation locationField;
34. private byte idField;
35. private string createdonField;
36. private string expiresonField;
37. ///
38. public flights_for_saleADAircraft aircraft
39. {
40. get
41. {
42. return this.aircraftField;
43. }
44. set
45. {
46. this.aircraftField = value;
47. }
48. }
49. ///
50. [System.Xml.Serialization.XmlElementAttribute("seller")]
51. public flights_for_saleADSeller[] seller
52. {
53. get
54. {
55. return this.sellerField;
56. }
57. set
58. {
59. this.sellerField = value;
60. }
61. }
62. ///
63. [System.Xml.Serialization.XmlElementAttribute("membership")]
64. public flights_for_saleADMembership[] membership
65. {
66. get
67. {
68. return this.membershipField;
69. }
70. set
71. {
72. this.membershipField = value;
73. }
74. }
75. ///
76. public flights_for_saleADLocation location
77. {
78. get
79. {
80. return this.locationField;
81. }
82. set
83. {
84. this.locationField = value;
85. }
86. }
87. ///
88. [System.Xml.Serialization.XmlAttributeAttribute()]
89. public byte id
90. {
91. get
92. {
93. return this.idField;
94. }
95. set
96. {
97. this.idField = value;
98. }
99. }
100. ///
101. [System.Xml.Serialization.XmlAttributeAttribute()]
102. public string createdon
103. {
104. get
105. {
106. return this.createdonField;
107. }
108. set
109. {
110. this.createdonField = value;
111. }
112. }
113. ///
114. [System.Xml.Serialization.XmlAttributeAttribute()]
115. public string expireson
116. {
117. get
118. {
119. return this.expiresonField;
120. }
121. set
122. {
123. this.expiresonField = value;
124. }
125. }
126. }
127. ///
128. [System.SerializableAttribute()]
129. [System.ComponentModel.DesignerCategoryAttribute("code")]
130. [System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
131. public partial class flights_for_saleADAircraft
132. {
133. private ushort yearField;
134. private string makeField;
135. private string modelField;
136. private string colorField;
137. private string descriptionField;
138. private string priceField;
139. private string idField;
140. ///
141. public ushort year
142. {
143. get
144. {
145. return this.yearField;
146. }
147. set
148. {
149. this.yearField = value;
150. }
151. }
152. ///
153. public string make
154. {
155. get
156. {
157. return this.makeField;
158. }
159. set
160. {
161. this.makeField = value;
162. }
163. }
164. ///
165. public string model
166. {
167. get
168. {
169. return this.modelField;
170. }
171. set
172. {
173. this.modelField = value;
174. }
175. }
176. ///
177. public string color
178. {
179. get
180. {
181. return this.colorField;
182. }
183. set
184. {
185. this.colorField = value;
186. }
187. }
188. ///
189. public string description
190. {
191. get
192. {
193. return this.descriptionField;
194. }
195. set
196. {
197. this.descriptionField = value;
198. }
199. }
200. ///
201. public string price
202. {
203. get
204. {
205. return this.priceField;
206. }
207. set
208. {
209. this.priceField = value;
210. }
211. }
212. ///
213. [System.Xml.Serialization.XmlAttributeAttribute()]
214. public string id
215. {
216. get
217. {
218. return this.idField;
219. }
220. set
221. {
222. this.idField = value;
223. }
224. }
225. }
226. ///
227. [System.SerializableAttribute()]
228. [System.ComponentModel.DesignerCategoryAttribute("code")]
229. [System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
230. public partial class flights_for_saleADSeller
231. {
232. private string idField;
233. private string phoneField;
234. private string emailField;
235. private string valueField;
236. ///
237. [System.Xml.Serialization.XmlAttributeAttribute()]
238. public string id
239. {
240. get
241. {
242. return this.idField;
243. }
244. set
245. {
246. this.idField = value;
247. }
248. }
249. ///
250. [System.Xml.Serialization.XmlAttributeAttribute()]
251. public string phone
252. {
253. get
254. {
255. return this.phoneField;
256. }
257. set
258. {
259. this.phoneField = value;
260. }
261. }
262. ///
263. [System.Xml.Serialization.XmlAttributeAttribute()]
264. public string email
265. {
266. get
267. {
268. return this.emailField;
269. }
270. set
271. {
272. this.emailField = value;
273. }
274. }
275. ///
276. [System.Xml.Serialization.XmlTextAttribute()]
277. public string Value
278. {
279. get
280. {
281. return this.valueField;
282. }
283. set
284. {
285. this.valueField = value;
286. }
287. }
288. }
289. ///
290. [System.SerializableAttribute()]
291. [System.ComponentModel.DesignerCategoryAttribute("code")]
292. [System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
293. public partial class flights_for_saleADMembership
294. {
295. private ushort idField;
296. private string fromField;
297. private string toField;
298. private string noField;
299. private string valueField;
300. ///
301. [System.Xml.Serialization.XmlAttributeAttribute()]
302. public ushort id
303. {
304. get
305. {
306. return this.idField;
307. }
308. set
309. {
310. this.idField = value;
311. }
312. }
313. ///
314. [System.Xml.Serialization.XmlAttributeAttribute()]
315. public string from
316. {
317. get
318. {
319. return this.fromField;
320. }
321. set
322. {
323. this.fromField = value;
324. }
325. }
326. ///
327. [System.Xml.Serialization.XmlAttributeAttribute()]
328. public string to
329. {
330. get
331. {
332. return this.toField;
333. }
334. set
335. {
336. this.toField = value;
337. }
338. }
339. ///
340. [System.Xml.Serialization.XmlAttributeAttribute()]
341. public string no
342. {
343. get
344. {
345. return this.noField;
346. }
347. set
348. {
349. this.noField = value;
350. }
351. }
352. ///
353. [System.Xml.Serialization.XmlTextAttribute()]
354. public string Value
355. {
356. get
357. {
358. return this.valueField;
359. }
360. set
361. {
362. this.valueField = value;
363. }
364. }
365. }
366. ///
367. [System.SerializableAttribute()]
368. [System.ComponentModel.DesignerCategoryAttribute("code")]
369. [System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true)]
370. public partial class flights_for_saleADLocation
371. {
372. private string cityField;
373. private string stateField;
374. ///
375. public string city
376. {
377. get
378. {
379. return this.cityField;
380. }
381. set
382. {
383. this.cityField = value;
384. }
385. }
386. ///
387. public string state
388. {
389. get
390. {
391. return this.stateField;
392. }
393. set
394. {
395. this.stateField = value;
396. }
397. }
398. }