Database For Visual Studio NET Developers

Database For Visual Studio Net Developers-Free PDF

  • Date:19 Jan 2020
  • Views:88
  • Downloads:0
  • Pages:46
  • Size:728.65 KB

Share Pdf : Database For Visual Studio Net Developers

Download and Preview : Database For Visual Studio Net Developers


Report CopyRight/DMCA Form For : Database For Visual Studio Net Developers


Transcription:

The information contained in this document represents the current view of Microsoft. Corporation on the issues discussed as of the date of publication Because Microsoft. must respond to changing market conditions it should not be interpreted to be a. commitment on the part of Microsoft and Microsoft cannot guarantee the accuracy of. any information presented after the date of publication. This White Paper is for informational purposes only MICROSOFT MAKES NO. WARRANTIES EXPRESS IMPLIED OR STATUTORY AS TO THE INFORMATION IN THIS. Complying with all applicable copyright laws is the responsibility of the user Without. limiting the rights under copyright no part of this document may be reproduced stored. in or introduced into a retrieval system or transmitted in any form or by any means. electronic mechanical photocopying recording or otherwise or for any purpose. without the express written permission of Microsoft Corporation. Microsoft may have patents patent applications trademarks copyrights or other. intellectual property rights covering subject matter in this document Except as. expressly provided in any written license agreement from Microsoft the furnishing of. this document does not give you any license to these patents trademarks copyrights. or other intellectual property, Unless otherwise noted the example companies organizations products domain. names e mail addresses logos people places and events depicted herein are. fictitious and no association with any real company organization product domain. name e mail address logo person place or event is intended or should be inferred. 2004 Microsoft Corporation All rights reserved, Active Directory Microsoft Visual Basic Visual C Visual C Visual Studio Windows. and Windows NT are either registered trademarks or trademarks of Microsoft. Corporation in the United States and or other countries. The names of actual companies and products mentioned herein may be the trademarks. of their respective owners,Contents 2,Abstract 5,Summary of Study Results 5. Introduction 6,Comparison of Core Technologies 6,Data Providers 7. NET Framework Integration 8,Implications of the Hosting Model 9.
Differences Between NET 2 0 and NET 1 1 9,Deploying NET Logic to SQL Server 10. Securing Assemblies in SQL Server 10,Deploying NET Logic to DB2 11. Visual Studio and SQL Server 2005 Integration 11,Visual Studio and DB2 UDB 8 2 Integration 13. Manageability and Performance 15,Technical Walkthrough 17. Description of SQL Server 2005 CLR Stored Procedure 17. Building a Stored Procedure with SQL Server and Visual Studio 2005 19. Summary of Steps in Development Process 19,Tools Integration 19.
Description of a DB2 CLR Stored Procedure 30, Building a Stored Procedure with DB2 and Visual Studio 32. Summary of Steps in Development Process 32,Tools Integration 32. Summary Comparison of the Developer Experience 41,Beyond the Relational Database 42. HTTP Endpoints 42,Service Broker 42,Notification Services 42. Reporting Services 43,Integration Services 43,Analysis Services 44.
Mobile Edition 44,Conclusion 45,About the Authors 46. This study compares and contrasts SQL Server 2005 with DB2 UDB v8 2 from the. perspective of a Visual Studio 2005 developer The study compares the core. technologies used by both SQL Server 2005 and DB2 UDB 8 2 such as NET Framework. integration support for language and other enhancements and performance and. manageability The study then follows the steps necessary to build debug and deploy a. stored procedure using SQL Server 2005 These steps are then compared to the steps. required to build debug and deploy the same stored procedure using DB2 The. intended audience for this article includes architects developers and technology. decision makers,Summary of Study Results, The study shows that the combination of SQL Server 2005 code named Yukon and. Visual Studio offers significant advantages over DB2 UDB 8 2 code named Stinger. and Visual Studio for building database applications These advantages will save. organizations both time and money as they develop debug and deploy database. solutions within their organizations Specifically this study demonstrates that SQL. Server 2005 supports a significantly wider range of NET database objects than DB2 UDB. 8 2 Additionally the SQL Server 2005 and Visual Studio combination provides a much. deeper level of integration than the combination of DB2 UDB 8 2 and Visual Studio for. building and managing database objects The study also demonstrates that beyond the. relational database development capabilities SQL Server 2005 offers an application. development platform that extends beyond the capabilities offered by DB2 UDB 8 2. Introduction, In the past the IT development world consisted of isolated lands of proprietary. knowledge of application development languages production environments and data. manipulation routines Building bridges between these islands of technology often. required specialized skills and was labor intensive Today with SQL Server 2005 and. Visual Studio 2005 we see a unified development environment that includes. programming models that span a broad range of software solutions from client based. database applications and server management utilities to the creation of server side. database objects Developers and customers alike receive the benefits of enhanced tools. and framework functionality which translates to a global increase in application. usability performance security and scalability, The integration of the Visual Studio environment and the database data providers that. are found in SQL Server 2005 and DB2 8 2 simplify and improve the application. development process They offer enhanced productivity tools for building and deploying. application programs resulting in better performance both in development time and. application manageability Both SQL Server 2005 s and DB2 UDB 8 2 s integration with. the NET Framework produce a more productive and flexible database application. development environment that results in better performing more robust database. solutions that possess better manageability and scalability than any of the previous. versions By taking advantage of NET integration database developers are able to. perform tasks that were impossible to achieve using just procedural SQL code Using the. NET Framework developers can write code that has more complex logic is better. suited to computation problem solving and can access external system and network. resources The NET languages like Visual Basic C and C are all fully object. oriented languages with capabilities such as encapsulation inheritance and. polymorphism They also provide full support for a number of features that aren t. present in SQL like support for arrays structured exception handling and collections. Microsoft NET delivers the most advanced and productive environment for building and. integrating database applications today In this study we will compare the different. levels of NET integration provided by SQL Server 2005 and DB2 UDB 8 2 To illustrate. the exact nature of each of the different product s integration capabilities we provide a. detailed technical walkthrough showing the exact steps required to build a sample NET. stored procedure using both SQL Server 2005 and DB2 UDB 8 2 with Visual Studio. Comparison of Core Technologies, While both SQL Server 2005 and DB2 UDB 8 2 are integrated with the NET Framework.
and Visual Studio there are some significant differences in the respective level of. integration provided by these products The following table presents the major. comparison points for the two database platforms with regard to the level of their NET. integration,NET Capabilities SQL Server 2005 DB2 UDB 8 2. Native NET Data Provider Yes SQL Server NET Yes DB2 NET Data. Data Provider Provider,NET Stored Procedures Yes Yes. NET User Defined Functions Yes Yes requires manual. NET Triggers Yes No,NET User Defined Types Yes No,NET User Defined Yes No. Aggregates,Visual Studio tooling Yes Yes,Data Providers. Both SQL Server 2005 and DB2 UDB 8 2 provide native NET Data Providers that enable. NET client applications to access the database platform These native providers offer. higher performance and better scalability for server applications as compared to. providers based on OLE DB These two providers offer very similar capabilities Both. providers implement the basic ADO NET Connection Command DataReader DataSet. and DataAdapter objects One key difference the SQL Server NET Data Provider is. made available in two modes one for client applications and one for server applications. This is particularly important for server side development because the SQL Server. server side NET Data Provider is an in memory provider that doesn t have the. networking overhead that s associated with client side data access providers Being an. in memory provider provides higher performance for NET database objects In addition. the separate server side provider exposes a set of capabilities such as server side. cursors that are only appropriate for server based code The provider for client. applications is exposed via the System Data SqlCient namespace while the NET Data. Provider for server side database objects is found in the System Data Sqlserver. namespace For DB2 UDB 8 2 there is the single IBM Data DB2 namespace The DB2. NET Data Provider uses the DB2Context object to create an in memory connection to. the database, On the server side again there are similarities Both DB2 and SQL Server support the.
creation and subsequent server side deployment of application logic in NET languages. Beyond this basic concept the level of NET integration with the two database platforms. is quite different DB2 UDB 8 2 supports the creation of NET stored procedures and user. defined functions However only the creation of DB2 UDB 8 2 NET Stored Procedures is. supported in the Visual Studio IDE DB2 UDB 2 NET Functions must be created. manually In contrast SQL Server 2005 provides much broader support for NET Like. DB2 SQL Server supports the creation of NET stored procedures and user defined. functions However SQL Server also supports NET for use within triggers user defined. types UDT s and user defined aggregates The creation of all of these objects is fully. integrated within the Visual Studio 2005 IDE The ability to build stored procedure and. functions using the NET languages enables the database developer to implement. business logic and perform complex functions that are beyond the capabilities of. standard SQL This is certainly a key point for NET interaction with the database but. the ability to use the NET languages to create triggers user defined types and. aggregates are just as important Using NET for triggers enables the trigger code to. more fully encapsulate business logic and perform additional actions such as accessing. external resources for logging operations The ability to create user defined types. enables the database developer to extend the native data types that are supplied with. the system UDT s defined with NET can have their own properties and operators. enabling the developer to seamlessly extend the native data types that are supported by. the server These UDTS can function exactly like native data types having their own. customer operators and aggregates Similarly the ability to support user defined. aggregates enables the developer to create custom aggregation operators that can be. used with either native or user defined data types. Beyond the basic set of NET features provided there are important differences in the. way that the NET Framework is integrated with the respective database servers The. next section will discuss the NET integration details in more depth. NET Framework Integration, Microsoft NET is a set of Microsoft software technologies for connecting information. people systems and devices The NET Framework is an integral Windows component. for building and running the next generation of software applications and Web services. The NET Framework,Supports over 20 different programming languages. Manages much of the plumbing involved in developing software enabling developers. to focus on the core business logic code, Makes it easier than ever before to build deploy and administer secure robust and. high performing applications, The NET Framework consists of the common language runtime CLR and a unified. factored hierarchical set of class libraries The NET CLR s responsibilities include run. time services for language integration security enforcement and management of. memory processing and threading In the area of language integration the CLR defines. the common type system CTS which describes the basic data types common across all. NET languages and the operations that pertain to those data types The NET. Framework provides an extensive set of classes that developers can incorporate into. their applications covering areas such as I O networking text processing data access. encryption XML processing Web services and more This allows developers to focus on. building business logic rather than plumbing code The integration of the NET CLR with. both SQL Server 2005 and DB2 UDB 8 2 enables the development of database objects. using any of the NET languages including C Visual Basic C and J. Visual Studio 2005 we see a unified development environment that includes programming models that span a broad range of software solutions from client based database applications and server management utilities to the creation of server side database objects Developers and customers alike receive the benefits of enhanced tools

Related Books