Solved

using LINQ with SQL Server 2012

Posted on 2013-11-07
3
614 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 63

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 63

Accepted Solution

by:
Fernando Soto earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Understanding the various editions available is vital when you decide to purchase Windows Server 2012. You need to have a basic understanding of the features and limitations in each edition in order to make a well-informed decision that best suits y…
The reason that corporations and businesses use Windows servers is because it supports custom modifications to adapt to the business and what it needs. Most individual users won’t need such powerful options. Here I’ll explain how you can enable Wind…
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

821 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