XML : xml to sql server issue

  <color name="red_50">#FFEBEE</color>  <color name="red_100">#FFCDD2</color>  <color name="red_200">#EF9A9A</color>  <color name="red_300">#E57373</color>  <color name="red_400">#EF5350</color>  <color name="red_500">#F44336</color>  <color name="red_600">#E53935</color>  <color name="red_700">#D32F2F</color>  <color name="red_800">#C62828</color>  <color name="red_900">#B71C1C</color>  <color name="red_A100">#FF8A80</color>  <color name="red_A200">#FF5252</color>  <color name="red_A400">#FF1744</color>  <color name="red_A700">#D50000</color>    

i want to parse this xml and insert to sql server table. Example: For #FFF3E0 I want to have : name:orange_50, hue:orange, value:50, hexcolor:#FFF3E0 which will be saved in db table. Thanks