Making Linq operations to a database in Data Connections

I am using Visual Studo 2012 and SQLExpress.

I am attempting to make Linq operations to a database in Data Connections. The database is on a local server on my computer. It already shows up in the Server Explorer -> Data Connections pane.

How do I actually obtain the data source to make operations against it in my program?

Answers


You have to add the Linq-to-SQL entity objects. In Visual Studio:

  1. Right click on your project and Add Item
  2. Add the LINQ to SQL Classes under Data
  3. Open the new DataClasses.dbml project file in VS
  4. Drag database objects (tables, stored procedures) onto the pane
  5. In your code, instantiate the DataContext class, and you're good to go.

Need Your Help

Implementing a button to do what file menu item does

c# .net user-interface

I have a menu item File -> Export. When I select that menu item, an export dialog box comes up.

How do I inline the :before element when unable to include a CSS/style section?

css html5 html-lists

I'm looking to style a li element, and would like to modify this CSS property:

JSF convertDateTime renders the previous day

java jsf date jsf-2

A date (as the Date temporal type) is stored in my DB like this: 31.10.2012

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.