Join Walt Ritscher for an in-depth discussion in this video Creating a data project with SQL Project, part of Visual Studio 2010 Essential Training.
Here is a problem that torments developer teams everywhere.…If you've ever worked with database changes and multiple developers, you know…that keeping your database schema in sync is a never-ending task.…If someone makes a change to the database schema, you must ensure that that…change propagates to each developer's computer, makes it to the test team, and…gets updated on all your production servers.…The trouble is compounded when debugging previous versions of your product.…Now you have to ensure that the database matches the code that is stored in…the source control.…
Some teams attempt to solve this problem by having a folder full of SQL scripts…that contain the information to update the schema.…These scripts can quickly get out of sync with the real database schema, however.…Believe me, I know this from first-hand experience.…To solve these problems, Microsoft created a special database project known as SQL project.…Before I continue, I should add that these features are only available in Visual…
- Creating a Visual Studio project
- Building the user interface
- Binding to an RSS feed
- Coding with IntelliSense
- Creating rich Internet applications with Silverlight
- Building Windows applications with Windows Forms
- Integrating with SQL Server
- Working with Microsoft Office applications
- Understanding extensibility in Visual Studio
- Working with data, ADO.NET and datasets
- Using source control
Skill Level Intermediate
Q: Which edition of Visual Studio 2010 do I need to follow along in this course?
A: The course is taught with Visual Studio 2010 Professional, but can also be used with the Premium or Ultimate editions. The Express editions of Visual Studio, including Visual Basic 2010 Express, Visual C# 2010 Express, and Visual C++ Express, are not covered in this course.
Q: I'm attempting to download the exercise files for this course, and my virus protection is blocking me from unzipping the downloaded file. Are the files corrupted?
A: The alert is a false-positive message. Your antivirus software is detecting the active code included in the exercise files, which in some ways resembles viral code. There is nothing to be alarmed about and you can ignore the warning. This is common among coding courses and environments.
1. Getting Started
2. Exploring the Visual Studio Workspace (IDE)
3. Building a Simple Application
4. Exploring the Code Editors
5. Working with Code
6. Understanding the Project Types
7. Digging Into Your Data
8. Debugging Your Application
9. Testing Your Application
10. Deploying Your Application
11. Working with Source Control
12. Integrating with Microsoft Office Applications
Making an Excel 2010 add-in5m 21s
13. Extending Visual Studio
14. Configuring Your Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.