ESENT –JET APIs to create database in Metro Style App on Windows 8

By -

ESENT –JET APIs to create database in Metro Style App on Windows 8-
ESENT dll is a part of windows SDK and provides apis to create and manage database on metro style application there is two major choices that can be used to implement databse in metro style application:
1.       SqlLite v3
2.       ESENT – JET database model
SQLLite3 is not officially annouced to be used as database engine on windows8. But winrt version is already available to play with database.
ESENT is already the part of windows8 so winrt support is already their to link esentlib statically to use the application.  JET apis are much flexible to create indexed base database and can be used to create huge database with thousands of table and columns.
JET apis introduced in different levels according to plateform like win2000, WINXP , VISTA and above.
Most of structures changed due to unicode support and security enhancement. I have created database using esent  - JET apis to work on metro style application the following example will demonstrate the steps to create database using native JET APIS.
Created a c ++ winrt component that will introduce classes and methods to work with database. This component can be used in metro style application created using any language like vc++ or c#.
The winrt component project will cretae .winmd file that will be added as referance to othe projects to call databse methods.
In given samle I have worked to provide basic functionality that can be used in metro style application to play with database:
1.       Initiating ESENT JET database engine
2.       Creation of database and table column
3.       Attach already created database and access table information and related details.
4.       Insertion of records
5.       Deletion of records from database.
Use following steps to create winrt component in VS:
1.       Create winrt project from template list
2.       Link the project with esent.dll
3.       And use sample code to start with database.
Use the winrt component in metro app written in c#
1.       Add referance->locate the .winmd file and add.
2.       Use the namespace and class in your project and go with it.
//JetDatabasecomponent.cpp
 

Comments

darichkid said…
Here is a database compatible with WinRT:
https://www.kellermansoftware.com/p-49-ninja-winrt-database.aspx
March 13, 2013 at 6:19 PM
Post a Comment

Popular posts from this blog

XML Programming using IXMLDOMDOCUMENT in vc++

By -
Here the sample code to start XML programming using XML dom parser. // TestXML1.cpp : Defines the entry point for the console application. // #import #include "stdafx.h" #include #include #include //sample xml u can copy paste it in note pad and save it with .xml extension and store in location c:\ int _tmain(int argc, _TCHAR* argv[]) { CoInitialize (NULL); CComPtr< IXMLDOMDocument > pXMlDoc = NULL; HRESULT hr = CoCreateInstance(__uuidof(DOMDocument), NULL, CLSCTX_INPROC_SERVER, IID_PPV_ARGS(&pXMlDoc)); VARIANT_BOOL boolval; CComVariant path ="c:\\cdcat.xml"; hr = pXMlDoc->load(path,&boolval); BSTR val ; pXMlDoc->get_xml(&val); MessageBox(0,val,_T("TEST"),0); pXMlDoc = NULL; CoUninitialize(); return 0; }
Read more

Get correct OS version on win 8.1 without using GetVesionEx API (deprecated )

By -
NTSTATUS (WINAPI *RtlGetVersion)(LPOSVERSIONINFOEXW); OSVERSIONINFOEXW osInfo; *(FARPROC*)&RtlGetVersion = GetProcAddress(GetModuleHandleA( "ntdll" ), "RtlGetVersion" ); if (NULL != RtlGetVersion) {    osInfo.dwOSVersionInfoSize = sizeof (osInfo);    RtlGetVersion(&osInfo); } Use above method on all  platform and it will work fine. Where GetOSVersionEx API deprecated by MS and gives wrong result on WIN 8.1.   Tested above sample on XP to 8,1 and works for me. There is another  alternative of manifest to use GetOSversionEx. Source: CodeProject  
Read more