Updating LINQ, DataContext Issue

And here is my current implementation.

var p = Repository.SelectByPK<Property>(editId);

                    p.listingTitle = txtListingTitle.Text;
                    p.status = int.Parse(dropStatus.SelectedValue);
                    p.propertyStyle = int.Parse(dropListingType.SelectedValue);
                    p.listingType = int.Parse(dropListingType.SelectedValue);
                    p.description = EditDescription.Content;
                    p.lotSize = txtLotSize.Text;
                    p.squarefeet = txtSquareFeet.Text;
                    p.bathrooms = dropBathrom.SelectedValue;
                    p.bedrooms = int.Parse(dropBedroom.SelectedValue);
                    p.address1 = txtAddress.Text;
                    p.zipcode = txtZipCode.Text;
                    p.state = int.Parse(dropState.SelectedValue);
                    p.city = int.Parse(dropCity.SelectedValue);
                    p.price = txtPrice.Text;
                    p.yearBuild = int.Parse(txtYearBuilt.Text);
                    p.GarageType = int.Parse(dropGarage.SelectedValue);
                    p.basementType = int.Parse(dropBasement.SelectedValue);
                    p.lastUpdated = DateTime.Now;

                    Repository.Update<Property>(p);

                    Response.Redirect("propertylist.aspx", false);

Select allOpen in new window

I usually create a single class, with a DataContext at the root level, that is shared with every method, and property.  I don't usually have any problem with this configuration, and there is a lot of code there to sift through, in order to find a needle in a haystack...

Hi.

Well unfortunately all of the code for this is in a single class and the datacontext is at the root level along with it.

I think it's got something to do with the fact that it is in another project? But I can't seem to pin it down yet.


Thanks.

You have defined a DataContext in the SelectByPK method:

    DataClassesDataContext context = new DataClassesDataContext();

Update<T> method:

    using (DataClassesDataContext context = new DataClassesDataContext())

If you have a module-level DataContext, then you don't need to create local instances inside of the methods.  Just use the module-level instance.

Tried the module level context and still receive the same error.

When you come to the DataContext.SubmitChanges, what does the DataContext.GetChangeSet look like?

It looks exactly the same as the data I pulled back from the database, the original object and that are identical.

It seems to be ignoring any changes I have made to the fields on the add/edit page I have. If I change a textbox or dropdown value, stepping through the code shows them to be the same as their original value.

I misspoke.

I didn't do the GetChangeSet correctly, but after adding it in properly I can see I have one update. The problem is that it only updates the p.lastUpdated property, and I have no idea why.

I debug, look at the web page itself and I see the new values, but when I step through the code, the values I'm seeing are the same as the original. I went ahead and took out the class I was using and just did an attempt to directly update right from that section, and exact same results in both places.

If I change the zipcode (or anything), why is it not showing up in the code properly when I debug? Only date update applies??

DataClassesDataContext context = new DataClassesDataContext();

                    var p = context.Properties.First(x => x.propertyId == int.Parse(editId));

                    p.listingTitle = txtListingTitle.Text;
                    p.status = int.Parse(dropStatus.SelectedValue);
                    p.propertyStyle = int.Parse(dropListingType.SelectedValue);
                    p.listingType = int.Parse(dropListingType.SelectedValue);
                    p.description = EditDescription.Content;
                    p.lotSize = txtLotSize.Text;
                    p.squarefeet = txtSquareFeet.Text;
                    p.bathrooms = dropBathrom.SelectedValue;
                    p.bedrooms = int.Parse(dropBedroom.SelectedValue);
                    p.address1 = txtAddress.Text;
                    p.zipcode = txtZipCode.Text;
                    p.state = int.Parse(dropState.SelectedValue);
                    p.city = int.Parse(dropCity.SelectedValue);
                    p.price = txtPrice.Text;
                    p.yearBuild = int.Parse(txtYearBuilt.Text);
                    p.GarageType = int.Parse(dropGarage.SelectedValue);
                    p.basementType = int.Parse(dropBasement.SelectedValue);
                    p.pool = dropPool.SelectedValue;
                    p.lastUpdated = DateTime.Now;

                   //Repository.Update<Property>(p);
                    System.Data.Linq.ChangeSet cs = context.GetChangeSet();
                    context.SubmitChanges();

                    Response.Redirect("propertylist.aspx", false);

Select allOpen in new window

Hmmm...diving deeper into LINQ...please wait while pressure equalizes...

I know that I have had problems with updates when I discovered the primary key column wasn't identified correctly on the .dbml designer.
Screenshot.png

I checked that as well, and it looks correct (just like your example).

Let me ask a question. I'm returning the object using the following code, and then assigning the properties of the object to their appropriate items on the aspx page.

Is there any reason to think the fields are being locked for some reason? Am I going about that the wrong way?

public void LoadProperty()
        {

            Property pEdit = Repository.SelectByPK<Property>(editId);
            txtListingTitle.Text = pEdit.listingTitle;
            dropStatus.SelectedValue = Convert.ToString(pEdit.status);
            dropPropertyStyle.SelectedValue = Convert.ToString(pEdit.propertyStyle);
            dropListingType.SelectedValue = Convert.ToString(pEdit.listingType);
            EditDescription.Content = pEdit.description;
            txtLotSize.Text = pEdit.lotSize;
            txtSquareFeet.Text = pEdit.squarefeet;
            dropBathrom.SelectedValue = Convert.ToString(pEdit.bathrooms);
            dropBedroom.SelectedValue = Convert.ToString(pEdit.bedrooms);
            txtAddress.Text = pEdit.address1;
            txtZipCode.Text = pEdit.zipcode;
            dropStatus.SelectedValue = Convert.ToString(pEdit.state);
            dropCity.SelectedValue = Convert.ToString(pEdit.city);
            txtPrice.Text = pEdit.price;
            txtYearBuilt.Text = Convert.ToString(pEdit.yearBuild);
            dropGarage.SelectedValue = Convert.ToString(pEdit.GarageType);
            dropBasement.SelectedValue = Convert.ToString(pEdit.basementType);

        }

Select allOpen in new window