How to update table in ASP.NET MVC 5 Razor Database

asp.net asp.net-mvc-5 c# entity-framework-6 razor

Question

I'm new to ASP.NET MVC 5 Razor and I need some help how can I upload rows in my database.

I also use EF6 existing database for my model.

This is what I'm trying to do:

@if (Request.QueryString["GetUser"] != null && Request.QueryString["Update"] == "Open")
                            {
                                ViewBag.Notification = "Do you want to sync " + @Request.QueryString["GetUser"].ToString() + " to ActiveDirectory2?";
                            }
                            @if (Request.QueryString["GetUser"] != null && Request.QueryString["Update"] == "Update")
                            {
                                using(GWActiveDirectory.Models.GW_UTAEntities db = new GWActiveDirectory.Models.GW_UTAEntities())
                                {
                                    var query = "UPDATE ActiveDirectory2"
                                              + " SET SamAccountName = '" + DataStorage.Rows[0][0].ToString() 
                                              + "', EmployeeNumber = '" + DataStorage.Rows[0][9].ToString()
                                              + "', GivenName = '" + DataStorage.Rows[0][4].ToString() 
                                              + "', Surname = '" + DataStorage.Rows[0][1].ToString() 
                                              + "', EmailAddress = '" + DataStorage.Rows[0][5].ToString() 
                                              + "', Enable = '" + DataStorage.Rows[0][3].ToString() 
                                              + "', Guid = '" + DataStorage.Rows[0][2].ToString()
                                              + "', SID = '" + DataStorage.Rows[0][6].ToString() 
                                              + "', DateCreated = '" + DataStorage.Rows[0][7].ToString() 
                                              + "', DateModified = '" + DataStorage.Rows[0][8] + "'"
                                              + " WHERE SamAccountName = @SamAccountName";
                                    db.ActiveDirectory2.SqlQuery(query,Request.QueryString["GetUser"])
                                    db.SaveChangesAsync();
                                    Response.Redirect("?SearchString=" + ViewBag.searchString + "&GetUser=" + Request.QueryString["GetUser"]);
                                }  

                            }

But the problem is when I try to run my program the table ActiveDirectory2 didn't update.

1
0
9/27/2014 5:15:26 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

SqlQuery is for querying. For updates you need to use ExecuteCommand. However you seem to want to use EF in which case you don't stitch SQL queries manually but you fetch the entity from the database you want to update, you set the properties and you call SaveChanges. Also note that in your code snippet the SaveChanges call does not make sense because it is a no-op. Because you bypass EF when updating the database the context does not track any entities so SaveChanges does nothing.

Finally the way you create your command is susceptible to a SQL injection attack. If you use EF the right way EF will build the command securely.

3
9/27/2014 5:45:05 AM

Related Questions

How to avoid certain fields to be updated in model using asp.net mvc 4

I am new to asp.net mvc 4 and EF. I am creating User Model which creates/updates user info. The code for model is as follows:....... public int UserID { get; set; } [Required] public string UserName { get; set; } [Required] public string Password { get; set; } [Compare("Password")] public string VerifyPassword { get; set; } ..... SOME OTHER ...
asp.net asp.net-mvc asp.net-mvc-4 c# entity-framework
asked by CodeWarrior

Use SQL Server database instead of local database asp.net mvc 5 database-first asp.net Identity tables

By default the connection settings for your database will be determined by a connection string named "DefaultConnection" which you cite in your question....The name of the appropriate connection string to use can in fact be changed in the constructor of the ApplicationDbContext class, changing from-...public ApplicationDbContext() : base("DefaultCo...
asp.net-identity asp.net-mvc ef-database-first entity-framework
asked by pwdst

How to Update/Edit multiple records using Entity Framework in ASP.NET MVC

I need to update multiple records, this is how far I could get...First, I tried this...foreach (var Product in Products) { Product.Price = Price; db.Entry(Product).State = EntityState.Modified; db.SaveChanges(); } ...But, I'm getting this error...Store update, insert, or delete statement affected an unexpected number of rows (0). E...
asp.net-mvc c# entity-framework
asked by Ahmed

Update db record in foreach loop with Entity Framework in asp.net mvc 6

I know there are similar questions, but in my case something is wrong. Just trying to update each row, but it does nothing for some reason and no errors. ...Thanks....public ActionResult Index() { using (var db = new DoskaUsContext()) { foreach (var category in db.Categories) { category.Count = 25; db...
asp.net asp.net-mvc c# entity-framework entity-framework-6
asked by Igor Levashov

Populate DropDownList in ASP.NET MVC from database table using Entity Framework 6 and ViewModel

I have been scratching my head for a whole night on an issue I can do quickly using ajax/jquery and stored procedures. I want to ...1) Populate a drop down list from values obtained from a database table using Entity Framework and view model. I DO NOT WANT TO USE VIEWBAG OR VIEWDATA. Any help appreciated....2) How can I generate a Create View using...
asp.net-mvc dropdownlistfor entity-framework razor viewmodel
asked by TropicalViking

How to update multiple models at the same time in ASP.NET MVC 5 Entity Framework

I think Umesh answer is correct. After changing your loop, how are you setting your Html.TextBoxFor, HiddenFor and so on?...It should be:...@Html.HiddenFor(m => m.ContentFields[i].Id)
asp.net-mvc entity-framework-6
asked by Emanuele Buccelli

how i update multiple table using viewmodel in Asp.net mvc

it worked for me just remove this ... db.Entry(user).State = EntityState.Modified; ...if we not remove this ...entityvalidation... occur
asp.net-mvc asp.net-mvc-viewmodel c# entity-framework-6 viewmodel
asked by Aliyange553

ASP.NET MVC database table getting null value

Your view contains a ...@Html.HiddenFor()... for each property before the associated ...EditorFor()... method. The ...DefaultModelBinder... only binds the first matching name/value pair and ignores the others, so its the values of the hidden inputs (which are default values) that are being saved....Remove all the ...@Html.HiddenFor()... from your v...
asp.net-mvc crud database entity-framework-6
asked by user3559349

How to update(by merging) edmx without override the model classes in asp.net mvc

I am developing an application in asp.net mvc. I use entity framework as ORM. I have a problem. To use javascript unobstrusive validation, I need to add annotation to model objects. For example; [Required], [EMailAddress]. But when we add something to the database and update it, all model classes are override, and all annotations disappear. Or, as ...
asp.net-mvc c# entity-framework entity-framework-6 orm
asked by user6172721

Update-database problem in asp.net MVC application

okay I solve the problem make ...int?... in foreign key ... [ForeignKey("AppointmentCustomer")] public int? AppointmentCustomerId { get; set; } [ForeignKey("AppointmentManager")] public int? AppointmentManagerId { get; set; } public virtual Users AppointmentCustomer { get; set; } public virtual Users ...
asp.net asp.net-mvc entity-framework-6 migration
asked by zied ben othman

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow