How can I prevent 'objects you are adding to the designer use a different data connection...'?

Posted by Timothy Khouri on Stack Overflow See other posts from Stack Overflow or by Timothy Khouri
Published on 2010-05-24T00:33:50Z Indexed on 2010/05/24 1:31 UTC
Read the original article Hit count: 489

Filed under:

linq-to-sql

|

visual-studio-2010

I am using Visual Studio 2010, and I have a LINQ-to-SQL DBML file that my colleagues and I are using for this project.

We have a connection string in the web.config file that the DBML is using. However, when I drag a new table from my "Server Explorer" onto the DBML file... I get presented with a dialog that demands that do one of these two options:

Allow visual studio to change the connection string to match the one in my solution explorer.
Cancel the operation (meaning, I don't get my table).

I don't really care too much about the debate as why the PMs/devs who made this tool didn't allow a third option - "Create the object anyway - don't worry, I'm a developer!"

What I am thinking would be a good solution is if I can create a connection in the Server Explorer - WITHOUT A WIZARD. If I can just paste a connection string, that would be awesome! Because then the DBML designer won't freak out on me :O)

If anyone knows the answer to this question, or how to do the above, please lemme know!

© Stack Overflow or respective owner

Related posts about linq-to-sql

how can i page my linq to sql result set

as seen on Stack Overflow - Search for 'Stack Overflow'
Remembering MySQL could use the instruction "limit" to indicate where I was starting my result set and how many wanted to have included. Select * FROM Users Limit [start], [Length] How can I do this in LinqToSql >>> More
LINQ to SQL and missing Many to Many EntityRefs

as seen on West-Wind - Search for 'West-Wind'
Ran into an odd behavior today with a many to many mapping of one of my tables in LINQ to SQL. Many to many mappings aren’t transparent in LINQ to SQL and it maps the link table the same way the SQL schema has it when creating one. In other words LINQ to SQL isn’t smart about many to many mappings… >>> More
Comparing LINQ to SQL vs the classic SqlCommand

as seen on Dot net Slackers - Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision… >>> More
Comparing LINQ to SQL vs the classic SqlCommand

as seen on Dot net Slackers - Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision… >>> More
LINQ to SQL Profiler

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In this article we will be taking a look at the new LINQ to SQL Profiler from HibernatingRhinos. This tool gives you a view into the goings on of LINQ to SQL. Not only does it allow you to see the SQL that is generated by your LINQ queries but it also shows you information about your connections… >>> More

Related posts about visual-studio-2010

La version gratuite de Visual Studio 2010 est disponible, Visual Studio 2010 Express introduit des o

as seen on Developper.com - Search for 'Developper.com'
Visual Studio 2010 Express est disponible La version gratuite de Visual Studio 2010 propose à présent des outils de développement pour Windows Phone 7 Alors que Visual Studio 2010 débarque avec ses nouveautés (lire par ailleurs ici), sa version gratuite Visual Studio Express 2010 vient d'être… >>> More
Are Visual Studio 2010 Professional Solutions/Projects 100% compatible with Visual Studio 2010 Premi

as seen on Stack Overflow - Search for 'Stack Overflow'
I am just wondering on what version of Visual Studio 2010 to install (Professional or Premium) If there are a few people in the team with a mix of VS2010 professional/premium, would opening solution/project files be an issue, ie incorrect version or prompts to upgrade prjects.. Projects include:… >>> More
[ASP.NET 4.0] Persisting Row Selection in Data Controls

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Data Control Selection Feature In ASP.NET 2.0: ASP.NET Data Controls row selection feature was based on row index (in the current page), this of course produce an issue if you try to select an item in the first page then navigate to the second page without select any record you will find the same… >>> More
Entity Framework Code-First to Provide Replacement for ASP.NET Profile Provider

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
A while back, I coordinated a project to add support for the SQL Table Profile Provider in ASP.NET 4 Web Applications. We urged Microsoft to improve ASP.NET’s built-in Profile support so our workaround wouldn’t be necessary. Instead, Microsoft plans to provide a replacement for ASP.NET Profile… >>> More
Tip#102: Did you know… How to specify tag specific formatting

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Let’s see this with an example. I have the following html code on my page. Now if I format the document by selecting Edit –> Format document (or Ctrl K, Ctrl D) The document becomes I want the content inside td should remain on the same line Read More......(read more) >>> More