Silverlight Database

Closed Issue: Lazy loading problem [5447]

SergeyBarskiy — Mon, 02 Nov 2009 13:33:11 GMT

Has a bug here

if (_useLazyLoading && !_loadedTables[typeof(T)])

use

!_loadedTables.ContainsKey(typeof(T))
Comments:

New Post: Deployment

sergeybarskiy — Mon, 19 Oct 2009 17:55:25 GMT

No, there are no restrictions.

New Post: Deployment

sunilsharma — Sun, 18 Oct 2009 23:07:00 GMT

Hi great project.

If you want to create a database structure and pre load it wih data and deploy it with your applications are there any restrictions fr different versions of windows.

Cheers,

Sunil.

New Post: RemoveRange Error?

JasonZheng — Mon, 28 Sep 2009 05:39:39 GMT

thank you for your Reply!

New Post: RemoveRange Error?

sergeybarskiy — Sat, 26 Sep 2009 01:12:03 GMT

Thanks for reporting this, Jason. I addressed the issue, updated the unit test to match the issues, created new release and posted it as recommended download. Feel free to download and try it out.

Thanks again

--Sergey

Created Release: Release 9-25-2009 (Sep 25, 2009)

sergeybarskiy — Sat, 26 Sep 2009 01:10:08 GMT

Address isssue with remove range error that was reported under discussions

Released: Release 9-25-2009 (Sep 25, 2009)

Sat, 26 Sep 2009 01:10:07 GMT

Address isssue with remove range error that was reported under discussions

Source code checked in, #34094

SergeyBarskiy — Sat, 26 Sep 2009 01:06:07 GMT

Update issue with saving a table with fewer rows than intially were there

New Post: RemoveRange Error?

JasonZheng — Fri, 25 Sep 2009 03:52:40 GMT

this maybe an Error?

if this method RemoveRangeConditionTest() change like this code:

        private void RemoveRangeConditionTest()
        {
            Database.DeleteDatabase("test");
            Database db = Database.CreateDatabase("test");
            db.CreateTable<Person>();

            Person person1 = new Person() { FirstName = "John ", LastName = "Doe ", Salary = 1, BirthDate = new DateTime(1900, 1, 1) };
            Person person2 = new Person() { FirstName = "John ", LastName = "Doe ", Salary = 2, BirthDate = new DateTime(1900, 1, 1) };
            Person person3 = new Person() { FirstName = "John ", LastName = "Doe ", Salary = 3, BirthDate = new DateTime(1900, 1, 1) };

            db.Table<Person>().Add(person1);
            db.Table<Person>().Add(person2);
            db.Table<Person>().Add(person3);
            db.Save();

db = Database.OpenDatabase("test");

db.Table<Person>().RemoveRange((person) => { return (person.Salary >= 2); });

            db.Save();
            if (db.Tables.Count == 1 && db.Table<Person>().Count == 1)
            {
                this.RemoveRangeViaConditionLabel.Foreground = new SolidColorBrush(Colors.Green);
            }
            else
            {
                this.RemoveRangeViaConditionLabel.Foreground = new SolidColorBrush(Colors.Red);
            }
        }

then run this test,there has an error,Xml file save like this:

<?xml version="1.0" encoding="utf-16"?>
<ArrayOfPerson xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Person>
    <FirstName>John </FirstName>
    <LastName>Doe </LastName>
    <BirthDate>1900-01-01T00:00:00</BirthDate>
    <Salary>1</Salary>
</Person>
</ArrayOfPerson><FirstName>John </FirstName>
    <LastName>Doe </LastName>
    <BirthDate>1900-01-01T00:00:00</BirthDate>
    <Salary>2</Salary>
</Person>
<Person>
    <FirstName>John </FirstName>
    <LastName>Doe </LastName>
    <BirthDate>1900-01-01T00:00:00</BirthDate>
    <Salary>3</Salary>
</Person>
</ArrayOfPerson>

the Red letter is error code,please check it,thanks a lot.

Reviewed: WCF Release (八月 24, 2009)

wxzself — Mon, 24 Aug 2009 07:28:23 GMT

Rated 5 Stars (out of 5) - MS not implementationm, but very needed.

Commented Issue: Lazy loading problem

SergeyBarskiy — Sun, 23 Aug 2009 17:57:14 GMT

Has a bug here

if (_useLazyLoading && !_loadedTables[typeof(T)])

use

!_loadedTables.ContainsKey(typeof(T))
Comments: ** Comment from web user: SergeyBarskiy **

Could you please provide some more details on this issue and steps on how to reproduce it in the latest release?
Thank you.

Reopened Issue: Lazy loading problem

SergeyBarskiy — Sun, 23 Aug 2009 17:55:55 GMT

Has a bug here

if (_useLazyLoading && !_loadedTables[typeof(T)])

use

!_loadedTables.ContainsKey(typeof(T))
Comments: ** Comment from web user: SergeyBarskiy **

Need more details

Closed Issue: Lazy loading problem

SergeyBarskiy — Sun, 23 Aug 2009 17:54:45 GMT

Has a bug here

if (_useLazyLoading && !_loadedTables[typeof(T)])

use

!_loadedTables.ContainsKey(typeof(T))
Comments:

This was fixed in BugFixRelease

Updated Wiki: Home

SergeyBarskiy — Sun, 23 Aug 2009 17:53:37 GMT

News:
New release is posted on 8/23/2009

This project implements a Isolated Storage (IsolatedStorage) based database for Silverlight. The usage of this software is very simple. You create a new database by Calling CreateDatabase. You can add tables to the database by calling db.CreateTable<T> where T is the type of entity to be stored in table rows. You can save database by calling Save, and open the database by calling OpenDatabase. This database supports version changes, so you can update your application and still be able to open the database. You can now also send/receive a database to/for WCF service without having to write any communicaiton code. You can look for basic use of this database by examining test Silverlight application. Encryption and compression have been implemented; just provide a password to use encryption. Compression is based on SharpZipLib - you will have all the rights specified under that project. See http://slsharpziplib.codeplex.com/license for details. Also lazy loading has been implemented. If you open database with lazy loading flag, tables will be loaded when first accessed. Feel free to look documentation help file under current download for API details. The source code file contains unit test project that you can also examine for usage details.

Here is a list features on the radar:

Isolated Storage quota checks, possibly with ability to automatically request more space

If you are prompted for password for signed key file, it is "SilverlightDatabase"

Please submit your comments and features requests, they are appreciated.
Let me know if you need additional documentation, and I will provide it.

Updated Release: WCF Release (Aug 23, 2009)

sergeybarskiy — Sun, 23 Aug 2009 17:52:52 GMT

This release includes the following functionality:
1. Ability to send/receive any database to /from WCF service without writing any communication code
2. .NET/WPF version of the database (byproduct of WCF service functionality)
Please see unit tests project for example on how to setup a solution for this functionality and how to send a database to/from a server. You will need to write and provide a class that does actual database processing after it has been received viw web.config file. See exampale for details.
Please start a new discussion if you have any questions.

Thanks.

Released: WCF Release (Aug 23, 2009)

Sun, 23 Aug 2009 17:52:52 GMT

Updated Release: WCF Release (Aug 23, 2009)

sergeybarskiy — Sun, 23 Aug 2009 17:47:11 GMT

Updated Release: WCF Release (Aug 23, 2009)

sergeybarskiy — Sun, 23 Aug 2009 17:39:55 GMT

Updated Wiki: Home

SergeyBarskiy — Sun, 23 Aug 2009 17:39:00 GMT

This project implements a Isolated Storage (IsolatedStorage) based database for Silverlight. The usage of this software is very simple. You create a new database by Calling CreateDatabase. You can add tables to the database by calling db.CreateTable<T> where T is the type of entity to be stored in table rows. You can save database by calling Save, and open the database by calling OpenDatabase. This database supports version changes, so you can update your application and still be able to open the database. You can now also send/receive a database to/for WCF service without having to write any communicaiton code. You can look for basic use of this database by examining test Silverlight application. Encryption and compression have been implemented; just provide a password to use encryption. Compression is based on SharpZipLib - you will have all the rights specified under that project. See http://slsharpziplib.codeplex.com/license for details. Also lazy loading has been implemented. If you open database with lazy loading flag, tables will be loaded when first accessed. Feel free to look documentation help file under current download for API details. The source code file contains unit test project that you can also examine for usage details.

Here is a list features on the radar:

Isolated Storage quota checks, possibly with ability to automatically request more space

Created Release: WCF Release (Aug 23, 2009)

sergeybarskiy — Sun, 23 Aug 2009 17:33:08 GMT