Run your modified query in your SQL browser to view the results. If a duplicate key is found, the query will update the existing column instead of erroring out. Advertisement ...

I'm fairly certain what you want to be using is DTS. It the wizard interface lives under Import/Export data. IMO, It's one of the best tools that has ever been designed for the computer.

Executing this query in SQL returns results such as: Now if you drop the view from your data model and re-add it, EF will pick up the real primary key column that is labeled NID and your LINQ ...