Creating and Indexing Email Database using SqlCe
- by Anindya Chatterjee
I am creating a simple email client program. I am using MS SqlCe as a storage of emails. The database schema for storing the message is as follows:
StorageId int IDENTITY NOT NULL PRIMARY KEY,
FolderName nvarchar(255) NOT NULL,
MessageId nvarchar(3999) NOT NULL,
MessageDate datetime NOT NULL,
StorageData ntext NULL
In the StorageData field I am…