The table could not be updated properly because it had no primary key. (Actually it had the column but the constraint was not copied when I did a SELECT INTO my dev table). The DataContext class requires a primary key for updates.
More Related Contents:
- LINQ-to-SQL vs stored procedures? [closed]
- Linq: adding conditions to the where clause conditionally
- LINQ Between Operator
- LINQ across multiple databases
- Learning about LINQ [closed]
- How can I reject all changes in a Linq to SQL’s DataContext?
- LINQ with SQLite (linqtosql)
- How to create a dynamic LINQ join extension method
- How to dynamically add OR operator to WHERE clause in LINQ
- LINQ To SQL exception: Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains operator
- Linq To Sql – Dynamic OrderBy – Case When
- Is there a pattern using Linq to dynamically create a filter?
- Linq to SQL how to do “where [column] in (list of values)”
- Multiple WHERE clause in Linq
- How do I write this cross apply query in LINQ-to-SQL?
- Point connectionstring in dbml to app.config
- Building Dynamic LINQ Queries based on Combobox Value
- NHibernate vs LINQ to SQL
- LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
- Entity Framework: There is already an open DataReader associated with this Command
- How can I conditionally apply a Linq operator?
- LINQ to SQL – Left Outer Join with multiple join conditions
- How to view LINQ Generated SQL statements?
- TransactionScope vs Transaction in LINQ to SQL
- How to write Asynchronous LINQ query?
- How do you perform a CROSS JOIN with LINQ to SQL?
- Sum of items in a collection
- Custom Method in LINQ to SQL query
- Greater Than Condition in Linq Join
- LINQ: How to convert the nested hierarchical object to flatten object