Solved

using LINQ with SQL Server 2012

Posted on 2013-11-07
3
616 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
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 they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
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…

752 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