Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

using LINQ with SQL Server 2012

Posted on 2013-11-07
3
Medium Priority
?
629 Views
Last Modified: 2016-02-10
I am using VS 2010 and I have added SQL to LINQ to my project. I have connected to my chosen database on SQL Server 2012. I am how ever not able to drag any tables into the design viewer.
0
Comment
Question by:Enigma_Koz
  • 2
3 Comments
 
LVL 64

Expert Comment

by:Fernando Soto
ID: 39630800
Please post the steps you take to create the model in your project and from where are you dragging the tables from. Some screen shots can also be of help.

Thanks
0
 

Author Comment

by:Enigma_Koz
ID: 39638408
Hi Fernando
Thank you for you reply.

1.) I right click my Project in Visual Studio, expand Add and then select New Item.
2.) From the Add New Item widow, I select LINQ to SQL Classes and click the Add button.
3.) From the properties pane I select Connection and create a new connection to my SQL Server 2012.
4.) From the server explorer I try drag the tables I need in to the dbml.
0
 
LVL 64

Accepted Solution

by:
Fernando Soto earned 1500 total points
ID: 39638750
Hi Enigma_Koz;

I have not been able to reproduce your issue. Please read the following post and do not stop reading after reading the initial question because it does not sound like your issue but the other post may provide some insight into your particular issue.

Visual Studio Database Tools Error
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Resolve DNS query failed errors for Exchange
In this Micro Tutorial viewers will learn how to restore their server from Bare Metal Backup image created with Windows Server Backup feature. As an example Windows 2012R2 is used.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question