Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

using LINQ with SQL Server 2012

Posted on 2013-11-07
3
Medium Priority
?
625 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 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

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…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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…

704 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