how to insert data using entity framework 6.0 in asp.net C#

Question

User-1647172364 posted

Hlo professionals!

I want to insert data using entity framework 6.0 in asp.net c#.

Answer 1

User753101303 posted

Hi,

You could start with the available documentation at https://docs.microsoft.com/en-us/ef/ or https://www.learnentityframeworkcore.com/

Forums are better suited for solving a particular problem you are running into rather than for learning something from scratch...

Answer 2

User1686398519 posted

Hi,  sanam13

If you can successfully connect to the database, you can refer to the simple example I gave.

Note:

• For how to connect to the database, you can refer to this link.
• To implement CRUD using EF, you can refer to this link.

Model3(This is a database context.)

 public class Model3 : DbContext
    {
        public Model3()
            : base("name=Model3")
        {
        }
        public DbSet<TestModel> TestModels { get; set; }
    }

Controller

        public Model3 db = new Model3();
        public ActionResult Add()
        {
            return View();
        }
        [HttpPost]
        public ActionResult Add(TestModel testModel)
        {
            if (testModel != null)
            {
                try
                {
                    db.TestModels.Add(testModel);
                    db.SaveChanges();
                    ViewBag.SUCCESS ="SUCCESS";
                }
                catch(Exception e)
                {
                    ViewBag.ERROR = e.Message;
                }
            }
            return View();
        }

Add

@model WebApplication3.Models.TestModel
@{
    ViewBag.Title = "Add";
}
<h2>Add</h2>
@ViewBag.SUCCESS
@ViewBag.ERROR
@using (Html.BeginForm("Add", "Test3"))
{
    @Html.DisplayNameFor(m => m.content)
    @Html.TextBoxFor(m => m.content)
    <button type="submit">submit</button>
}

Here is the result.

 
Best Regards,

YihuiSun

Answer 3

User-1647172364 posted

And how to update data using entity framework in asp.net C #