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 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

C++ Class Member Initialization order....

By -
Sample Code.... class Test { int x; int y; public:Test(int z) { x=y=z; } }; class Test1 { Test t; const int b; Test1(int z):t(1),b(10) { } }; CSomeClass::CSomeClass() { x=0; y=1; } and in other places I see it written this way: CSomeClass::CSomeClass() : x(0), y(1) { } Some of my programmer friends say that it's better to do it the second way, but no one knows why. Can you tell me the difference between these two methods of initializing class members? A Technically your friends are right, but in most cases it makes no difference. There are two reasons to use the second syntax, which is called a member initialization list: one is necessity, the other efficiency. Let's examine the first reasonâ€"necessity. Suppose you have a class member that is itself a class or struct, and this class only has one constructor that requires an argument. class CMember { public: CMember(int x) { ... } }; Since CMember has an explicit constructor, the compiler do...
Read more