FullText Search for Silverlight 4 Database

New integrated Lucene FullText Search Engine for Silverlight 4 database. Currently only supports creating FullText indexes with CREATE TABLE statement and Querying FullText index with MySQL style MATCH .. AGAINST expression.

Download EffiProz+Lucene from http://www.effiproz.com/downloads/effiproz_lucene.zip

Silverlight 4 Out-of-Browser Databases in local file system special folders

New EffiProz database for Silverlight 4 support creating databases in local file system special folders such as "My Documents", "My Pictures", etc. You will need to run your application Out-of-Browser with elevated trust.

Following is a sample connection string to connect to "testsl4" database in "My Documents" folder,
"Connection Type=file;  Auto Commit=false; Initial Catalog=|MyDocuments|/testse; User=sa; Password=;"

Few other special folder names recognized by effiproz are,
|ApplicationData|, |CommonApplicationData|, |Desktop| , |LocalApplicationData|, |MyPictures|

Just start the initial catalog name with one of the special folder names and database files will get created in corresponding local file system folder.

If you care using Query Tool for Silverlight, you can start database name with one of the special folder names as follows,

Check EffiProz for Silverlight 4 Live Demo at http://www.effiproz.com/SL4QTDemo.aspx