PDP NET Final

Pick Data Provider for .NETProducts:- D3 Data Provider for .NET- mvBase Provider for .NET- U2 Data Provider for .NET©2006 Raining Data Corporation. All rights reserved. All products or service names mentioned herein are trademarks of their respective owners. : Pick Data Provider for .NET Products: - D3 Data Provider for .NET - mvBase Provider for .NET - U2 Data Provider for .NET ©2006 Raining Data Corporation. All rights reserved. All products or service names mentioned herein are trademarks of their respective owners.


What is .NET ? : What is .NET ?


.NET Framework : .NET Framework


Why .NET is Important : Why .NET is Important Increased Productivity Dramatically Simplifies Application Development Secure Provides a Robust and Secure Execution Environment Multilanguage Capability Supports Multiple Programming Languages Cross-Language Class Use Develop in One Language and Reuse in Another or All Simplifies Deployment and Management .NET is Building Market Momentum More than 4 M Developers (3.5+ MB CDs And 700+ KB Downloads)


Gartner Group Research (2003) : Gartner Group Research (2003) About e-Business Application Development Programming: “Together, Microsoft and Java technologies will command 80% or more of new e-business application development (AD) initiatives through 2008.” Migration Trends: “We expect C++, Visual Basic, C# and Java to be used to satisfy the majority of AD language demands through 2007. Most successful innovative initiatives will be based on, or be highly leveraged by, one of these languages.” Support for Global Class Solutions: “Microsoft has significantly closed the gap with Java in many areas of global-class technology and has even leapfrogged in many areas.” Who Will Use What: “Small and Medium Businesses (SMB) will generally be able to choose one technology as their primary focus… Microsoft .NET architecture will be more attractive to those businesses.” “We expect .NET … to continue to apply pressure in higher-end software markets during the next five years.”


Slide6 : ASP.NET VB.NET C# C++.NET J# OLE DB .NET OLE DB ODBC .NET PickDP.NET ODBC Pick D3 – mvBase - IBM UniVerse - UniData .NET Data Access for Pick


Slide7 : PickDP.NET Object Model


PickDP.NET Advantages and Features : PickDP.NET Advantages and Features Supports All .NET Programming Languages Exposes the Inherent Capabilities of the Pick Data Model Single Fields Associations Queries Application-To-Application Bridge Subroutine Calls Remote Command Execution Pre- and Post-Processing Event Handling


PickDP.NET Advantages and Features : PickDP.NET Advantages and Features Smart Pick Data Binding to Visual Objects Visual Assignment Process Tags and Visual Objects with Data Elements Intelligent Typing and I/O Conversion Visual Object Extensions for Data Manipulation Locking Handler Extensions Optimistic and Pessimistic Locking, and Timeout Control


PickDP.NET Advantages and Features : PickDP.NET Advantages and Features Event Handler and Method Extensions Pre- and Post-Processing File I/O and Updates Error Management Multiple Connections Handling to Different Databases and Systems Local, Remote or Foreign Non-Pick Databases Optimistic and Pessimistic Locking, and Timeout Control Data Management Administration Tools Accounts, Tables, Records, and Server Base Code


Product Tour : Product Tour


Installation : Installation


PickDP.NET Architecture - Server : PickDP.NET Architecture - Server Database Server PickDP inetd Service PickDP Account From / To Client


Service Configuration : Service Configuration PickDP.NET Inetd Servers Configuration Utility


PickDP.NET Database Administration : PickDP.NET Database Administration


PickDP.NET Database Administration : TCL Command Tab PickDP.NET Database Administration Screen Editor for BASIC Programs Edit, Compile and Catalog BASIC Code


PickDP.NET Administrator Benefits : PickDP.NET Administrator Benefits Single Point of Administration Table Repository Independent of Dictionary Definitions Create/Edit/Import/Export Dictionary Elements Create/Enable Table Repository Access Enables Account Access for .NET Development Establish Security Parameters for Account Access Create/Edit/Compile/Catalog Basic Programs TCL Command Tab


Installation : Installation


PickDP.NET Architecture - Client : PickDP.NET Architecture - Client HTTP SOAP Web Server Client/Server Application .NET IDE .NET Framework PickDP.NET Application or PickDP.NET Add-in To Server


PickDP.NET Development Resources : PickDP.NET Development Resources


PickDP.NET Development Resources & Benefits : PickDP.NET Development Resources & Benefits Complete Integration with Visual Studio .NET IDE Class Library Extensions Offer Direct Access to Pick Database Engine Pick-like Functions, Constants and Conversions Pick/BASIC Interface Smart Data-bound Multivalue Aware Visual Objects Dynamic Help, F1, and Intellisense Sample Demonstration Programs


Building a PickDP.NET Application : Building a PickDP.NET Application


Step 1 - Building a PickDP.NET Application : Step 1 - Building a PickDP.NET Application Create a Menu Form


Step 2 - Building a PickDP.NET Application : Step 2 - Building a PickDP.NET Application


Step 3 - Building a PickDP.NET Application : Step 3 - Building a PickDP.NET Application Drag and drop Table and Data Binding objects


Step 4 - Building a PickDP.NET Application : Step 4 - Building a PickDP.NET Application


Step 5 - Data Binding the Visual Objects : Step 5 - Data Binding the Visual Objects


PickDP.NET Table Methods : PickDP.NET Table Methods


Step 6 - Writing Event Handler Code : Step 6 - Writing Event Handler Code One function call to the DB Binder fills all attributes in the record


Step 7 - Writing Event Handler Code : Step 7 - Writing Event Handler Code The DB Binder functions are Boolean expressions They also provide error message facilities for debugging


Step 8 - Writing Event Handler Code : Step 8 - Writing Event Handler Code


Step 9 - Writing Event Handler Code : Step 9 - Writing Event Handler Code


Step 10 - Writing Event Handler Code : Step 10 - Writing Event Handler Code


You are Done ! : You are Done ! VB.NET Demo VC#.NET Demo VJ#.NET Demo


Deployment Requirements : Deployment Requirements


Persistent Connection : Persistent Connection .NET Framework Windows 98 Client D3, mvBase, UniVerse, UniData DBMS .NET Framework Windows NT .NET Framework Windows 2K/XP PickDP.NET DB Upgrade Licenses Windows 2003 .NET Framework


Less Persistent Connection (Web) : Less Persistent Connection (Web) .NET Framework Windows 98 D3, mvBase, UniVerse, UniData DBMS .NET Framework Windows NT .NET Framework Windows 2K/XP PickDP.NET DB Upgraded Licenses Windows 2003 .NET Framework


Deployment Licenses : Deployment Licenses


Features and Benefits : Features and Benefits


Pick Data Provider for .NET – D3 and mvBase : Pick Data Provider for .NET – D3 and mvBase


Pick Data Provider for .NET – U2 : Pick Data Provider for .NET – U2


Application Development Strategies : Application Development Strategies


Pick Data Provider for .NET : Pick Data Provider for .NET


Pricing and Availability : Pricing and Availability


Pick Data Provider for Visual Studio .NET : Pick Data Provider for Visual Studio .NET Server Requires D3 Release 7.3 or Later on UNIX Platform or 7.3.6 or Later for D3 NT Server Requires mvBase 2.0 with Patch Set 3 or Later on Windows Platform Server Requires UV 9.6 or Later Server Requires UDT 5.2 or Later Client Requires Microsoft Visual Studio .NET 2003 Professional Edition Enterprise Developer Edition Enterprise Architect Edition Microsoft .NET Framework 1.1 Microsoft Visual J# .NET Redistributable Package 1.1


Pick Data Provider Database Server Access License Upgrade for .NET : Pick Data Provider Database Server Access License Upgrade for .NET Required for Deployment of .NET Solution Server Requires D3 Release 7.3 or Later on UNIX Platform and D3 7.3.6 or Later for D3 NT Server Requires mvBase 2.0 with Patch Set 3 or Later on Windows Platform Server Requires UV 9.6 or Later Server Requires UDT 5.2 or Later NT, Linux, and UNIX Platforms Supported Client Plug-Ins are Free and Included with Database Server Access License Upgrade


Related Links : Related Links What is .NET? http://www.microsoft.com/net/basics/whatis.asp .NET Framework http://msdn.microsoft.com/netframework Pick® Data Provider for .NET http://www.rainingdata.com/products/connect/dotnet


Raining Data Corporation Technology for Innovative Solutions : Raining Data Corporation Technology for Innovative Solutions www.rainingdata.com