Click here to Skip to main content
       

ASP.NET

 
AnswerRe: Change root path PinmemberRichard Deeming10-Dec-12 2:35 
GeneralRe: Change root path PinmvpJohn Simmons / outlaw programmer10-Dec-12 2:42 
AnswerRe: Change root path Pinmember@AmitGajjar11-Dec-12 8:10 
QuestionUpdating the column using entity framework Pinmemberindian1437-Dec-12 13:46 
Hi All,
 
I am trying to update a database table using entity framework, but some how I dont know why, but entity framework is updating the other column of the table which I am not setting up in my code. In my update statement after else statement, I am calling to update only column docid (rq.doc_id = doc_id) but I dont know why it is updating even the request_status column also. It is updating with 4 spaces and updating thats all.
I am actually not resetting the request_status value. It is very strange for me.
 
Can any body please help me in resolving this and getting rid of this problem.
 
I have my code as below
 
           Using _databasefactory As New DatabaseFactory()
                Dim context = _databasefactory.DatabaseContext
 
                If Not String.IsNullOrEmpty(temp_doc_id) AndAlso Not String.IsNullOrEmpty(doc_id) Then
                    Dim reqs = (From r In context.requests Where r.claim.claim_no.Equals(claim_no) AndAlso r.temp_doc_id.Equals(r.temp_doc_id)) 'r.empl_accnt_no.Equals(emplacctnumber) AndAlso _

                    Dim res = 0
                    If reqs Is Nothing Then
                        Dim rq = New request()
                        rq.claim = (From r In context.claims Where r.claim_no.Equals(claim_no)).FirstOrDefault()
                        rq.empl_accnt_no = emplacctnumber
                        rq.manual_claim_no = ManualClaimNo
                        rq.doc_id = doc_id
                        rq.temp_doc_id = temp_doc_id
                        rq.request_status = "OANEW"
                        rq.last_update_ts = DateTime.Now
                        rq.create_ts = DateTime.Now
                        rq.comments = String.Empty
                        context.AddTorequests(rq)
                        Return context.SaveChanges()
                    ElseIf reqs.Count() <= 0 Then
                        Dim rq = New request()
                        rq.claim = (From r In context.claims Where r.claim_no.Equals(claim_no)).FirstOrDefault()
                        rq.empl_accnt_no = emplacctnumber
                        rq.manual_claim_no = ManualClaimNo
                        rq.doc_id = doc_id
                        rq.temp_doc_id = temp_doc_id
                        rq.request_status = "OANEW"
                        rq.last_update_ts = DateTime.Now
                        rq.create_ts = DateTime.Now
                        rq.comments = String.Empty
                        context.AddTorequests(rq)
                        Return context.SaveChanges()
                    Else
                        Dim rq = reqs.FirstOrDefault()
                        'If Not rq.claimReference.IsLoaded Then
                        '    rq.claimReference.Load()
                        'End If
                        rq.doc_id = doc_id
                        res = context.SaveChanges()
                        Return res
                    End If
                End If
            End Using
Thanks & Regards,
 
Abdul Aleem Mohammad
St Louis MO - USA

Questionasp.NET composite control cannot raise an event Pinmembermichal.cerbak7-Dec-12 5:50 
Questionhow to convert hex to rgb color code in asp.net PingroupDeenuji vellore7-Dec-12 0:14 
AnswerRe: how to convert hex to rgb color code in asp.net PinmvpRichard MacCutchan7-Dec-12 1:32 
Questionasp.net threads, see if thread with same name is running to wait a couple of seconds Pinmemberjkirkerx6-Dec-12 11:45 
AnswerRe: asp.net threads, see if thread with same name is running to wait a couple of seconds PinmentorKeith Barrow7-Dec-12 6:21 
GeneralRe: asp.net threads, see if thread with same name is running to wait a couple of seconds Pinmemberjkirkerx7-Dec-12 7:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 25 Nov 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid