Using Sqlite in a Xamarin.Android Application Developed using Visual Studio

<div dir="ltr" style="text-align: left;" trbidi="on"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJfSscmpGeKCWGxog3nZ9RM2g2gec0URKZ9YGZZCCyyGj49vYEfOr-QXNbEHOhwopj8C0ex17zX3db-jwoUtWuNDV1EFi85p4Elo7628CHEAAQp78qdFe2EhBpU7axUvXzMlSAxbcoNnY/s1600/android-sqlite.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJfSscmpGeKCWGxog3nZ9RM2g2gec0URKZ9YGZZCCyyGj49vYEfOr-QXNbEHOhwopj8C0ex17zX3db-jwoUtWuNDV1EFi85p4Elo7628CHEAAQp78qdFe2EhBpU7axUvXzMlSAxbcoNnY/s1600/android-sqlite.png" width="320"></a></div> <h2 style="background-color: white; color: #ff9900; font-family: 'Segoe UI', Arial, sans-serif; font-size: 30px; font-weight: 200; margin: 20px 0px 11px; padding: 0px 0px 10px;"> <span style="color: #111111; font-size: 14px;">If you have ever developed an Android application using the Xamarin plug-in for Visual Studio, then chances are that you will have had a requirement to store and retrieve data. Although your application may initially receive its data via a web service, you may want to store the data on the device so that you do not need to keep requesting it from your web services. Unless your data is highly volatile, then storing the data on the device in a database makes sense. Data that is retrieved from local storage will be quicker than remote data retrieved via web services and is not at the mercy of connectivity problems if you are in a bad signal area. It is up to the developer to decide exactly what data they want to store locally, and how often they update that data.</span></h2></div>

If you have ever developed an Android application using the Xamarin plug-in for Visual Studio, then chances are that you will have had a...

Read more »

Setup Mono for Android on Windows - Tutorial

<div dir="ltr" style="text-align: left;" trbidi="on"> <header> <h1 class="entry-title"> Setup Mono for Android on Windows - Tutorial</h1> </header> <div class="entry-content"> After a short (3 weeks) adventure with Windows 8 I’ve decided I don’t want to struggle with the system (nor constantly switch back to ‘Desktop’ mode after another accidental switch to ‘no-longer-called-Metro-UI’) and so I came back to well known, liked, cozy Windows 7 x64. This is the system I’ve been using at work for a little more than last 3 years (basically since day one it RTM-ed) and the one I split time when developing at home - 50/50 with Mac OS X. I’m a convert from iOS church to the Android - the mobile OS that brought me to my knees with Samsung’s Galaxy S III (I’ll post about it on another occasion). And so I wanted to get at least a little bit familiar with developing for Android, however I wasn’t that much enthusiastic when I thought about a perspective of switching development environment to Eclipse and programming language I use on daily basis to Java. Fortunately <a href="http://xamarin.com/">Xamarin</a> offers the tooling that allows developers to develop for Android (as well as iOS and Mac) using C# and Visual Studio (as an option).<br /> <br /> <strong>Note: The best thing you can do is to head over to <a href="http://xamarin.com/trial">Xamarin - trials</a> and after registering - run the setup. Mono for Android installer should automatically detect which of the prerequisites are missing from your system. However in my case (and as Google search results show I’m not the only one) - this didn’t work. Also - you need to have a paid version of Visual Studio (Express edition won’t suffice as it does not support 3rd party extensions). I also think - following step-by-step guide gives you a better understanding of the pieces of the puzzles involved, than clicking ‘next’ a few times in the installer</strong><br /> So here are the steps required to configure Mono for Android on Windows, with Visual Studio, to enable developing for Android mobile devices in C#:<br /> <ul> <li>Download Java Software Development Kit 6 <a href="http://www.oracle.com/technetwork/java/javase/downloads/jdk6u38-downloads-1877406.html">Java SDK 6</a> - do NOT pick x64 version (even if you are on x64 version of Windows), go for x86 version. Also for Mono for Android 4.2.5 - that’s the one I’ve been using - Java SDK 6 is required (it won’t work with JDK 7 - although you can have both installed on your system side-by-side)</li> <li>Download <a href="http://developer.android.com/sdk/index.html">Android SDK</a> - click on the ‘Download SDK Tools for Windows’ (ADT Bundle includes Eclipse, which is not the option I wanted to go for)</li> <li>After Android SDK is installed Android SDK Manager will run. This allows installing different APIs (these depend on the Android version you would like to target). In my case I went for API 16 (Android 4.1.2), SDK tools, Android device emulator. Pick what you see fit.</li> <li>Now it’s time to configure your AVD (Android Virtual Device) <img alt="Choosing AVD option from Android SDK Manager menu" src="http://content.screencast.com/users/o3tker/folders/Jing/media/32527848-afdc-422f-97b5-d5955127fcc4/2012-12-26_2246.png" /></li> </ul> This is the emulator that will simulate a real physical device, when you will be testing your application written in C#, with Mono for Android (to deploy to real device you need to buy a licensed version from Xamarin). There are many different Android devices in the wild, differing in screen size, screen resolution, hardware capabilities, memory size, etc… The best way to setup AVD as so its configuration would reassemble a real device is to do a Google Search e.g. for ‘Android AVD configuration for Galaxy S III’. One thing to note here is that what is important is screen’s resolution, API version - which may vary, depending on which Android version you have installed on your handset. So for example for Galaxy S III bought in Poland in 2012 - 90% you’d get a 4.0 (Android Ice Cream Sandwich). However my handset has a custom ROM installed, which is based on the latest 4.1.2 (Android Jelly-Bean) and so I’d pick API16 rather than API15. You can check the version of the ROM (Android) installed on your phone by going to Settings->About device and checking value on ‘Android version’. So - the information Googled + info about your phone will tell you everything you need to know to successfully setup your AVD. First, switch to ‘Device definitions’ tab and then click ‘New device’ button. Set it up like so: <img alt="Geekbeing's new device - Galaxy S III" src="http://content.screencast.com/users/o3tker/folders/Jing/media/9e3c6687-96da-4334-9e70-2d0f0357646d/2012-12-26_2313.png" /> Next, based on this device - create your AVD, mine looks like that (<strong>Note: if later on, when trying to run your application on AVD - when it fails - change RAM size from 1024MB to 512MB - I haven’t figured out why, but it seems like AVD is unable to boot when setup with more memory than 512MB - and Visual Studio fails silently - waiting forever for Virtual Device to boot up</strong>):<br /> <img alt="Geekbeing's choice for Galaxy S III AVD" src="http://content.screencast.com/users/o3tker/folders/Jing/media/50c5e525-ed70-4ecf-8188-e4b392b9884b/2012-12-26_2315.png" /><br /> <ul> <li>Go to <a href="http://xamarin.com/trial">Xamarin’s page for downloading trials</a>, pick Mono for Android, provide information about yourself and hit download. Run the installer.</li> </ul> After everything has been installed, you can now run Visual Studio and verify whether everything’s setup properly. Begin your adventure by clicking File -> New Project and configure it like so: <img alt="Geekbeing - new project, new adventure" src="http://content.screencast.com/users/o3tker/folders/Jing/media/46ac354a-a25e-4191-adee-0f84cb66e9f0/2012-12-27_0042.png" /> After the project has been created hit ctrl+shift+b to build the solution. If everything is installed and properly configured, you should end up with an output log similar to this one: <img alt="Geekbeing - merry output log" src="http://content.screencast.com/users/o3tker/folders/Jing/media/063f5f73-c54e-4a56-b215-12606297b2cc/2012-12-27_0048.png" /><br /> Here are some materials to get you started: <a href="http://docs.xamarin.com/android/guides">Mono for Android Tutorials and Guides</a> for free, or should you prefer the book and have some dime to spend - <a href="http://www.wrox.com/WileyCDA/WroxTitle/Professional-Android-Programming-with-Mono-for-Android-and-NET-C-.productCd-1118026438.html">Professional Android Programming with Mono for Android and .NET/C#</a>, happy coding!</div> </div>

Setup Mono for Android on Windows - Tutorial After a short (3 weeks) adventure with Windows 8 I’ve decided I don’t want to struggle ...

Read more »

Using a Database in MonoDroid Applications

<div dir="ltr" style="text-align: left;" trbidi="on"> The stock database available in Android is <a href="http://www.sqlite.org/" target="_blank">SQLite</a>, and chances are you’ll find yourself wanting to use it in your applications. But how do you go about doing so? In this post I’ll go over some options for accessing the database, exploring both the standard Android patterns and also an example of plugging in an ORM to simplify things.<br> </div>

The stock database available in Android is SQLite , and chances are you’ll find yourself wanting to use it in your applications. But how ...

Read more »