March 2003
Beginner
412 pages
12h 42m
English
Content preview from Mastering Visual Studio .NET
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 5. Databases
Many applications rely on database management systems, such as SQL Server or Oracle, to provide robust, high-performance storage and retrieval of information. Visual Studio .NET provides tools that enable you to design, maintain, and use databases and that help you manage changes as your application evolves.
Visual tools help you design database objects such as tables, queries, and relationships. Visual Studio .NET is able to observe the changes you make with these tools and save them in a Database project. This allows any changes you make to a development server to be applied at a later date to other servers (e.g., staging servers and production servers). Code generation facilities are also available in certain project types that automate the retrieval and storage of data. For example, .NET projects allow data adapters and type-safe datasets to be created from database schemas. You can also use all of the visual database tools without needing a project at all—they can all be accessed through the Server Explorer.
Tip
The various editions of Visual Studio .NET offer different levels of support for database work. Section 5.4 shows what level of support each of the editions offers for the various database types.
Table 5-1. Database support in Visual Studio .NET editions
|
Feature |
Enterprise Architect/Developer |
Professional |
Standard |
|
Browse MSDE or Access |
X |
X |
X |
|
Browse any OLE DB data source |
X |
X | |
|
Design MSDE databases |
X |
X | |
|
Design any OLE DB data source |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.