Category: "Open source resources"
Sqlite is good for a standalone system
I have been asked to build a library management system for my church. That is very very simple system. The system only needs to track the borrow records. I don't think that even needs a database. Orginally, I planned to use serialization for storing the records. But if in future, they want the records to be viewable on our church website as well. Then I need to port the records to the database and change the application to use a database. OK, maybe, that is good to install mySQL in the computer. Well, that is too over-kill the resources. So, I found Sqlite. It can relpace the flat system to store the record. Moreover, it has an ADO.Net driver and is fully supported by NHibernate. In the future, I can port the codes to another database technology by changing database driver in NHibernate. Finally, I chose Sqlite as the data storage.
MonoDev 2.0
MonoDev is getting well developed. Now, it has an ASP.Net Toolbar and even it has database explorer!
A careless mistake in ActiveRecord for MySql
I am writing a program for myself by using ActiveRecord. I am an MS SQL Server Develper. So, I just did in a careless mistake. I called a table , User. If you call a table will crash with system table name, we use '[' and ']'. I hardcoded the table name in '[User]' in a Model class for ActiveRecord. I can't create a schema by Active Record. Because in MySql, we use '`'. So, it should be
Code
[ActiveRecord("`User`")] | |
| |
public class User : ActiveRecordBase |
Not
Code
[ActiveRecord("[User]")] | |
| |
public class User : ActiveRecordBase |
Windows Mobile without Visual Studio
http://www.codeproject.com/KB/mobile/WiMoSansVS.aspx
That is a good article to teach yourself for the mobile application in SharpDevelopment