Solved

using LINQ with SQL Server 2012

Posted on 2013-11-07
3
607 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 62

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 62

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

My GPO's made for 2008 R2 servers were not allowing me to RDP into a new 2012 server by default.  That’s why I tried to allow RDP via Powershell, because I could log into a remote shell without further configuration. Below I will describe how I wen…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
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 configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now