Silverlight: Phone Database Project

See more:

Mobile

Silverlight

database

Hi everyone,

I am creating a database using the following code:

(name is constant string)

using SilverlightPhoneDatabase;
Database DB;
const string name = "MyDatabase";

private void CreateDBTest()
        {
            if (Database.DoesDatabaseExists(name) == false)
            {
                if (Database.CreateDatabase(name) != null)
                {
                    DB = Database.CreateDatabase(name);
                    DB.Save();
                }
            }
            else
            {
                tbDbExists.Text = "DB Already Exists...";
            }
        }

and then I create a table -

private void CreateTableTest()
        {
            DB = Database.OpenDatabase(name);

            DB.CreateTable<person>();

            if (DB.Table<person>() != null)
            {
                DB.Table<person>().Add(NewPerson());
                if (DB.Table<person>().Count == 1)
                {
                    tbTableCreated.Text = "Table Created...";
                }
            }
            else
            {
                tbTableCreated.Text = "Table Not Created...";
            }
        }</person></person></person></person>

where Person is a class with properties like FirstName, LastName etc.
and NewPerson is a function -

private Person NewPerson()
        {
            return new Person() 
            { 
                FirstName = "John", LastName = "Doe",
                Salary = 100          
             };
        }

Now when I create the database, it persists, and each time I try to create the database with same name, it says that it already exists. This is OK but when I create the table once, it doesn't persist for the next time. What should I do?

Thanks.