Insert XML data in database

private void ConvertXmlToClass()

{

try

{

XDocument doc = XDocument.Load(@"C:\Users\sana-user\Documents\Visual Studio 2015\Projects\SVGXMLToJsonApp\SVGXMLToJsonApp\File\3rect.svg");

string jsonText = JsonConvert.SerializeXNode(doc);

dynamic dyn = JsonConvert.DeserializeObject(jsonText);

dynamic svg = dyn.svg;

var result = new Svg

{

g = new List(),

svgStyle = GetString(svg, "@style"),

id = GetString(svg, "@id"),

x = GetString(svg, "@x"),

y = GetString(svg, "@y"),

viewBox = GetString(svg, "@viewBox"),

cssStyle = GetString(((IDictionary)svg)["style"] as ExpandoObject, "#text"),

};

foreach (ExpandoObject gObj in svg.g)

{

var g = new G

{

Id = GetString(gObj, "@id"),

};

if (IsPropertyExist(gObj, "rect"))

{

var rect = ((IDictionary)gObj)["rect"] as ExpandoObject;

g.Rect = new Rect

{

Class = GetString(rect, "@class"),

id = GetString(rect, "@id"),

height = GetString(rect, "@height"),

width = GetString(rect, "@width"),

x = GetString(rect, "@x"),

y = GetString(rect, "@y"),

};

}

if (IsPropertyExist(gObj, "text"))

{

var txt = ((IDictionary)gObj)["text"] as ExpandoObject;

g.Text = new Text

{

Class = GetString(txt, "@class"),

id = GetString(txt, "@id"),

TextData = GetString(txt, "#text"),

transform = GetString(txt, "@transform"),

};

}

result.g.Add(g);

}

}

catch (Exception e)

{

Console.WriteLine(e);

throw;

}

}

private string GetString(ExpandoObject obj, string key)

{

return ((IDictionary)obj)[key] as string;

}

private bool IsPropertyExist(dynamic settings, string name)

{

if (settings is ExpandoObject)

return ((IDictionary)settings).ContainsKey(name);

return settings.GetType().GetProperty(name) != null;

}