At the moment, we installed the first of two necessary elements. Now in conjunction with the drafting of the article is the version 3.8.7.4, so all the exercises will be with this version. Image 1.2 The engine of SQLite for Windows Phone 8.1. In the next dialog box, on the left we expand the "Extensions", if we have correctly installed the engine then we will find SQLite among the available extensions as shown in the following figure. First, add the reference to the Engine for Windows Phone, in the project in the Solution Explorer, right-click on "References", and we're going to select "Add Reference". Image 1.1 The templates available for development on Windows Phone.Īssuming that the development environment is initialized correctly, as specified in the introduction, let's add all the necessary extensions to interact with SQLite. In templates available to the "Windows Phone Application", select "Blank Application (Windows Phone)" and assign the project the name "SQLite Sample" as shown in the figure. We will create an application using C# as the development language. From the File menu, select "New" and then "Project". In my case I used the professional version. Once downloaded and installed, it will add to the project that we will slowly create in the course of the article. Let's pay attention to one thing, in this case, we will install the appropriate extension to Windows Phone Store, but if we wanted to develop a Windows Store, we need to install the engine suitable, because if we have a project Universal App, it is not a single application, but we are faced with a project that eventually will create two separate applications for the platform. The first thing to do, since there is support of data in the Windows Runtime, some extensions to be installed in order to interact with SQLite, the first is found at this link. Until now, it was made a simple introduction on what and SQLite, but for more details and explanations, refer to the official source. Finally, you can use some methods exstension (such as Language Integrated Query (LINQ)), to be precise LinqToObject that we will see in the article. E-platform, then over Windows Phone Store and is compatible with Windows Store, Android and other platforms. Written in C++, SQLite provides excellent performance in terms of execution and the performance of any operation, working in disconnected mode, unlike for example SQL Server, where there is a service called DBMS for interaction with data. SQLite is an open source engine, created and supported by the SQLite Consortium supported by the Windows Runtime thanks to compatibility with C++. For this reason, the useful approach is to use a database and an excellent choice to resort to is SQLite. Although very important and easy to use, the disadvantages are that all the information must still be kept in memory at the expense of delays and that impacts on the performance of the application. Currently, the Windows Runtime has no native support of databases, but provides the ability to serialize / deserialize data in various formats including XML and JSON. As developers, you know that the support of the storage of information, such as settings or other data, is very important. This first article introduces a very important tool related to storing data permanently in our device.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |