How to Insert Data From XML File to Sql Table

Hello,

I Have two tables as Listed below :

1) EmployeeMaster

CREATE TABLE [dbo].[EmployeeMaster](

[EmpId] [int] NOT NULL Primary Key,

[EmpName] [nvarchar](50) NULL

)

2) EmployeeRole

CREATE TABLE [dbo].[EmployeeRole](

[RoleId] [int] NOT NULL,

[RoleName] [varchar](50) NULL,

[EmpId] [int] NULL

)

Also I am Having MasterData.xml also

Adhikar

Amit

Admin

Employee

So Now i want to insert this xml file data into EmployeeMaster and EmployeeRole table in MVC. So please give me the solution.