How to insert data to SQL Server DB using EF in MVC 2?

Question

How do insert data to a SQl Server 2008 database server using Entity Framework from a user input on a web application.

I added a new EF connection o my model. I am able to see all the mappings correctly.

I currently have the following in my view:

m.PhoneNumber) %>

and in my controller

 public ActionResult DialTone(Models.TelephoneModels telephone)
        {
            List<string> callType = new List<string>();
            callType.Add("Standard");
            callType.Add("Emergency");
            ViewData["TypeOfCalls"] = new SelectList(callType);
            if (!ModelState.IsValid)
            {
                return View("DialTone", telephone);
            }

            ViewData["Number"] = "You are currently connected to: " + telephone.PhoneNumber;

            using (LogEntities db = new LogEntities())
            {
                var log = db.Logs.Single(m => m.PhoneNumber == telephone.PhoneNumber);
                TryUpdateModel(log);
                db.SaveChanges();
            }


            return View();

I want to log all phone numbers (or strings) that the user inputs in the TextBox - phonenNumber into the database.

I created a LOG database table with a column called "PhoneNumber". I cant seem to figure out how to insert the data into the table.

Any ideas?

Thanks!

:)

Mage · Accepted Answer · 2010-07-13 17:45:35Z

1

I figure it out. I used:

 using (LogEntities db = new LogEntities())
            {
                Random random = new Random();
                Log p = new Log();
                p.ID = "400"; //Just a test
                p.PhoneNumber = telephone.PhoneNumber;
                db.AddToLogs(p);
                db.SaveChanges();
            }

answered Jul 13, 2010 at 17:45

Mage

9692 gold badges13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert data to SQL Server DB using EF in MVC 2?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related