I am trying to use LinqToSql with SQL Compact 3.5 .sdf database. I created
the database and successfully added the file to my project. I used SQLMetal
to generate the .DBML files, and that seems to have been successful. I
created a form and placed a datagrid view object on the form and I have tried
several ways of trying to bind the data from the database to the grid.

I can load the data grid with the data without any problems, but any changes
I make to the data grid doesn't seem to make it back to the database. I have
been able to set up another data grid with direct binding to the class in the
DBML files. In this experiment it seemed the when I executed the
submitchanges() command the data in the objects got changed. However, when I
checked the data base the data was unchanged. If I shut the application down
without rebuilding and the start it up the changes seem to persist. However,
if I rebuild the application the changes are lost and the original values
from the data base are loaded.

To bind the data to the grid, on the form load event I create a new
bindingsource and set its data source property to the result of my linq
query. I then set the datasource property of my datagridview to the binding
source. Then to update any changes I have a button with a clickevent that
calls the SubmitChanges() command.

I thought that any changes to the data grid would propagate down to the
class objects, which it seems it does, and then the submit changes would
then move that data to the database, which is where I am stuck.

I have been stuck on this now for 2 weeks and I am out of ideas. Any help
would be greatly appreciated.

Hi Jamie,

When the application is complied, the .dbml file is by default copied to
the bin folder, this copied file is the one where the update are occurring,
but you're viewing the original .dbml file, so you're seeing no update.

The value of "Copy to Output Directory " property of the dbml file is set
to "Copy Always" by default, which means the .dbml file in the bin folder
will be copied every time you build, debug, or run your application. So
when you run the application the next time, the .dbml file will be
overwritten to the orignial version, if you don't want the database to be
overwritten every time, you can set the value of the "Copy to Output
Directory" to "Copy If Newer ", check this MSDN document for more
information:

Local Data Overview
http://msdn.microsoft.com/en-us/library/ms233817(VS.80).aspx

If anything is unclear, please feel free to let me know.

Best Regards,
Zhi-Xin Ye
Microsoft Managed Newsgroup Support Team

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg (AT) microsoft (DOT) com.

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Jamie,

How about the issue now? Does my suggestion make sense to you? If you have
any questions or concerns, please feel free to let me know, I will be happy
of assistance.


Best Regards,
Zhi-Xin Ye
Microsoft Managed Newsgroup Support Team

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg (AT) microsoft (DOT) com.

This posting is provided "AS IS" with no warranties, and confers no rights.