none
WCF service to insert XML element values into SQL database table RRS feed

  • Question

  • Hi all,

    Anyone knows how to write a WCF service that insert data into database using repository pattern, LINQ to Entity Framework, please help me soon. 

    I can do it in ADO.NET but I am new with above technology. Your time to help me with sample code are much appreciated. I searched online but I am not sure how to start???

    I did the following steps:

    1. Created a WCF Service Application that take XML string to parse them into XML element values as following:

    <SCHOOLRECORD>

        <NAME>Robert</NAME> 

        <GRADE>9</GRADE>

        <DATE>1-20-2013</DATE>

    </SCHOOLRECORD>

    I parsed above XML into three parameters: paramNAME = Robert, paramGRADE = 9 and paramDATE = 1-20-2013. Now I would like to insert element values into SchoolRecord table with columns (id, Name, Grade, Date) where id is unique key which generated from system. 

    2.  I am not sure how to organize the project structure for DAL(data access layer), Entities, Business Logic and how to using Repository pattern for LINQ to Entity Framework. Please help me to get start. Thanks in advance.

    Friday, February 8, 2013 6:29 AM

Answers

All replies