LINQ - SubmitChanges() does not update field in DB

Posted on 2011-10-24
Last Modified: 2012-05-12
Hi, I am trying LINQ for the first time,
and it is of course making problem to me :)
It does not give error, I google a lot to find a solution.
And my table (MS SQL 2008) has a primary key.

                            DataClasses1DataContext db = new DataClasses1DataContext(KLIS.Helpers.myConnections.GetConnectionString());
                            //var IPs = from p in db.T_MRO_IPs select p;

                            T_MRO_IP mro = db.T_MRO_IPs.Single(p => == id);
                            mro.lastReply = DateTime.Now;
                            //DataTable dt = KLIS.Helpers.myConnections.GetDataTableText("UPDATE T_MRO_IP SET lastReply=" + date.);

Open in new window

Question by:exceter
    LVL 3

    Assisted Solution

    Hi Exceter,

    the surrounding brackets make me suspect that you have this enclosed in a transaction? If this is the case, did you call Complete on the transaction?
    LVL 3

    Accepted Solution

    The surrounding barckets are just a loop. I have not paste here a full code
    LVL 3

    Author Closing Comment

    There was no solution, giving points for try

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how the fundamental information of how to create a table.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now