The Objects you are adding tot the designer use a different connection than the designer is currently using. Do you want to replace the connection used by the designer?

Question

Hi I am using Linq To Sql designer for CRUD operations. So far i am working on only one database and no issues. To i got a view from different database. i am getting message "The Objects you are adding tot the designer use a different connection than the designer is currently using. Do you want to replace the connection used by the designer?" when i  drag and drop the view on the designer. I don't want to create another dbml file. Could you please guide me to resolve this issue?
Thanks
Ravi

Answer 1

There can't be 2 connections for one DataContext instance.
If you don't want to use several contexts, please tune access rights for the main connection in order to have the select privilege for the user you are connecting with.

---

Devart Team
http://www.devart.com/dotconnect
ADO.NET data providers for Oracle, MySQL, PostgreSQL, SQLite with Entity Framework and LINQ to SQL support