How to insert Data using Entity Framework

In below code i will explain about How to insert data into sql using Entity Framework.
I have used Database first model approach.

HTML File:

<html xmlns="http://www.w3.org/1999/xhtml">
<head>

    <title></title>
    <script src="js/jquery.min.js"></script>
    <script>
        function SubmitData() {

            var name = 'Ram';
            var gender = 'Male';
            var age = '30';
        
            
          
            $.ajax({
                type: "POST",
                url: "ajaxcall.aspx/SaveData",
                data: '{"name":"' + name + '", "gender":"' + gender + '", "age":"' + age + '"}',
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                beforeSend: function () {
                    $('#loader').show();
                },
                success: function (data) {
                   
                    alert(data.d);
                    $('#loader').hide();
                },
                error: function (msg) {
                    //alert('3');
                    msg = "There is an error";
                    alert(msg);
                    $('#loader').hide();
                }
            });

        }
    </script>
</head>
<body>
    <div id="loader" style="display: none;">
        <img src="ajax-loader.gif" />
    </div>
    <a href="#" onclick="SubmitData();">Submit</a>
</body>

</html>

ASPX page

    [WebMethod]
    public static string SaveData(string name, string gender, string age)
    {
        try
        {
            var test = new Test();
            test.age = Convert.ToInt16(age);
            test.gender = gender;
            test.name = name;


            using (var ctx = new TestEntities())
            {
               
                ctx.Test.Add(test);
                ctx.SaveChanges();
            }

            return “OK”;
        }



        catch (Exception ex)
        {

            return ex.Message;
        }

        finally
        {

        }
    }

Comments

Popular

C# 6.0 New Features

SharePoint Interview Questions and Answers

Calling ASP.Net WebMethod using jQuery AJAX

What is Cloud Computing - A guide for beginners