I just uploaded and published new CodePlex project I have been working on. It is an Isolated Storage based database for Windows Phone 7. I converted my existing Silverlight database project I published a long time ago and adapted it to Windows Phone 7. It supports multiple strongly typed tables, basic Linq based operations, addition and deletion of ranges of items, deletion of items based on condition. You can also directly bind data to UI in Silverlight because base table inherits from ObservableCollection. It supports encryption along with lazy loading of table.
Please take a look at http://winphone7db.codeplex.com/
Here are key classes of the project. ITable interface makes it easy to write generic code in Database class. It is a simple interface as you can see:
using System;using System.IO;namespace SilverlightPhoneDatabase.Core{/// <summary>/// Interface that is used for tables in a database/// </summary>public interface ITable{/// <summary>/// Type of object that database contains/// </summary>Type RowType { get; }/// <summary>/// Save table le to the Isolated Storage/// </summary>void Save();/// <summary>/// Write content of a table to a file stream/// </summary>/// <param name="stream">Stream to write table to</param>void WriteDTableToStream(Stream stream);/// <summary>/// Set internal variables data when a table is de-serialized/// </summary>/// <param name="databaseName">Database name that table belongs to</param>/// <param name="password">Password to use for encryption</param>void SetTableDefinition(string databaseName, string password);}}I use XML Serializer to store table to Isolated Storage:
using (IsolatedStorageFile store = IsolatedStorageFile.GetUserStoreForApplication()){string fileName = string.Concat(_databaseName, ".", typeof(T).FullName);#if SILVERLIGHTif (store.FileExists(fileName)){store.DeleteFile(fileName);}#elseif (store.GetFileNames(fileName).Length > 0){store.DeleteFile(fileName);}#endifusing (IsolatedStorageFileStream stream = new IsolatedStorageFileStream(fileName, FileMode.OpenOrCreate, store)){WriteDTableToStream(stream);}}
Writing data to stream is very easy:
/// <summary>/// Write content of a table to a stream/// </summary>/// <param name="stream">Stream to write table to</param>public void WriteDTableToStream(Stream stream){string content = string.Empty;using (StringWriter stringWriter = new StringWriter()){XmlSerializer serializer = new XmlSerializer(this.GetType());serializer.Serialize(stringWriter, this);stringWriter.Flush();content = stringWriter.GetStringBuilder().ToString();if (!string.IsNullOrEmpty(_password)){content = Cryptography.Encrypt(content, _password);}stringWriter.Close();}using (StreamWriter writer = new StreamWriter(stream)){writer.Write(content);writer.Flush();writer.Close();}}The most interesting part of Database class is probably table loading. This is done via generic function Table<T>:
/// <summary>/// FInd instance of a table that contains specific row type/// </summary>/// <typeparam name="T">Type of object that this table contains</typeparam>/// <returns></returns>public Table<T> Table<T>(){ITable returnValue = (from oneTable in Tableswhere oneTable.RowType == typeof(T)select oneTable).FirstOrDefault();if (_useLazyLoading && !_loadedTables[typeof(T)]){Type tableType = typeof(Table<>).MakeGenericType(new Type[] { typeof(T) });string fileName = string.Concat(_databaseName, ".", typeof(T).FullName);using (IsolatedStorageFile store = IsolatedStorageFile.GetUserStoreForApplication()){using (IsolatedStorageFileStream tableStream = new IsolatedStorageFileStream(fileName, FileMode.Open, store)){LoadTable(tableStream, tableType);tableStream.Close();}}_loadedTables[typeof(T)] = true;returnValue = (from oneTable in Tableswhere oneTable.RowType == typeof(T)select oneTable).FirstOrDefault();}return (Table<T>)returnValue;}
I would very much appreciate comments and feature requests related to this project.
Thanks in advance for the feedback.