The Zen ADO.NET Core data provider supports data access to any .NET-enabled application or application server. It delivers high-performance point-to-point and n-tier access to industry-leading data stores across the Internet and intranets. Because it is optimized for the .NET environment, the ADO.NET Core data provider allows you to incorporate .NET Core technology and extend the functionality and performance of your existing system.
The following topics cover features that pertain to the Zen ADO.NET data provider:
•.NET Standard 2.0, which supports .Net Core 2.0 + For a full support matrix of .NET Standard 2.0, see http://immo.landwerth.net/netstandard-versions/#
•UWP applications
Creating an Application in Visual Studio Using Zen ADO.Net Core DLL
Before using these steps, first download the latest SDK .zip archive and extract the NuGet package Pervasive.Data.SqlClientStd for your version as listed under ADO.NET Data Providers Available with SDK Download.
►To create an application in Visual Studio using Zen ADO.Net Core DLL
1 In Visual Studio, on the File menu, point to New, and then click Project. The New Project window appears.
2 In the left pane, in the Installed list, select the .Net Core template for Visual C#.
3 In the middle pane, select the required project type.
4 Enter the name and location for the project in the respective fields, then click OK.
5 Right-click the project, then click Properties.
6 In the Build pane, in the Platform target list select the required platform.
7 Add the downloaded NuGet package to the project.
To learn how to add the NuGet package locally, see https://stackoverflow.com/questions/10240029/how-do-i-install-a-nuget-package-nupkg-file-locally/38663739#38663739
Creating a UWP Application in Visual Studio Using Zen ADO.Net Core Data Provider
Before using these steps, first download the latest SDK .zip archive and extract the NuGet package Pervasive.Data.SqlClientStd for your version as listed under ADO.NET Data Providers Available with SDK Download.
Note: For a UWP application to use Zen ADO.Net Core DLL, the required Windows 10 operating system version is 1709 (OS Build 16299) or later.
►To create a UWP application in Visual Studio using Zen ADO.Net Core data provider
1 In Visual Studio, on the File menu, point to New, and then click Project. The New Project window appears.
2 In the left pane, in the Installed list for Visual C#, select Windows Universal, then in the middle pane, select Blank App (Universal Windows).
3 Enter the name and location for the project in the respective fields; then click OK.
4 In the Minimum Version list, select Windows 10 Fall Creators Update (10.0; Build 16299).
5 In the MainPage.xaml file, add a button, and then rename the button to Connect to Pervasive.
6 Double-click the button to open its implementation.
7 Add the following to the button implementation code:
8 Add the downloaded NuGet package to the project.
To learn how to add the NuGet package locally, see https://stackoverflow.com/questions/10240029/how-do-i-install-a-nuget-package-nupkg-file-locally/38663739#38663739
9 If the database is available in a remote machine, in the package.appxmanifest file on the Capabilities tab, select the Private Networks (Client & Server) check box.
10 Build and run the application.
ADO.NET Data Provider Features Missing in Zen ADO.NET Core Data Provider
The following Zen ADO.NET data provider features are missing in Zen ADO.NET Core data provider:
•Performance Counters: As performance counters are not supported by ADO.Net Core, they are not supported by Zen ADO.Net Core data provider either.
•Encoding: As Zen ADO.Net data provider was only created for Windows-based applications, it uses Windows-1252 encoding (identified by code page 1252) as the default encoding.
Since Zen ADO.Net Core data provider is a cross-platform data provider, it uses the default encoding of the current operating system as its default encoding.
•CreatePermission in PervasiveFactory: As CreatePermission (PermissionState) method is not supported by ADO.Net Core, it is not supported by Zen ADO.Net Core data provider either.
•Fill Schema: Zen ADO.Net data provider uses Encoding.BodyName for Char, VarChar, and LongVarChar columns while pushing the data to the user. Since Encoding.BodyName is not supported by ADO.Net Core, the Zen ADO.Net Core data provider uses Encoding.WebName.
