Click here to Skip to main content
       

ASP.NET

 
AnswerRe: Display Images from a database in a tile view PinmemberAli Al Omairi(Abu AlHassan)10-Dec-12 2:23 
Questionlinq connection in asp.net PinmemberJonBrynjar8-Dec-12 3:58 
AnswerRe: linq connection in asp.net Pinmember@AmitGajjar11-Dec-12 7:00 
QuestionChange root path PinmvpJohn Simmons / outlaw programmer8-Dec-12 3:40 
AnswerRe: Change root path PinmemberRichard Deeming10-Dec-12 1:35 
GeneralRe: Change root path PinmvpJohn Simmons / outlaw programmer10-Dec-12 1:42 
AnswerRe: Change root path Pinmember@AmitGajjar11-Dec-12 7:10 
QuestionUpdating the column using entity framework Pinmemberindian1437-Dec-12 12: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 4:50 
Questionhow to convert hex to rgb color code in asp.net PingroupDeenuji vellore6-Dec-12 23:14 
AnswerRe: how to convert hex to rgb color code in asp.net PinmvpRichard MacCutchan7-Dec-12 0:32 
Questionasp.net threads, see if thread with same name is running to wait a couple of seconds Pinmemberjkirkerx6-Dec-12 10:45 
AnswerRe: asp.net threads, see if thread with same name is running to wait a couple of seconds PinmentorKeith Barrow7-Dec-12 5:21 
GeneralRe: asp.net threads, see if thread with same name is running to wait a couple of seconds Pinmemberjkirkerx7-Dec-12 6:47 
QuestionPagination worries Pinmembercizu6-Dec-12 5:12 
AnswerRe: Pagination worries Pinmemberdeflinek7-Dec-12 1:40 
AnswerRe: Pagination worries PinmemberAnkitGoel.com10-Dec-12 17:33 
QuestionHtml Mail Formate Error Pinmembermukusingh5-Dec-12 18:49 
AnswerRe: Html Mail Formate Error Pinmemberjkirkerx6-Dec-12 10:41 
GeneralRe: Html Mail Formate Error Pinmembermukusingh6-Dec-12 19:18 
Questionhow to set og tag at runtime PinmemberJassim Rahma5-Dec-12 9:12 
AnswerRe: how to set og tag at runtime Pinmemberdeflinek7-Dec-12 1:50 
Questionis this a correct og prefix? PinmemberJassim Rahma5-Dec-12 7:36 
Questionasp.net vb PinmemberNada ALsalami5-Dec-12 3:09 
AnswerRe: asp.net vb Pinmemberryanb315-Dec-12 4:34 

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
Web02 | 2.8.140926.1 | Last Updated 30 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid