Windows Phone Mango Local Database(SQL CE): [Table] attribute

published on: 7/19/2011 | Views: N/A | Tags: Mango LocalDB

by WindowsPhoneGeek

This is the third post from the "Windows Phone Mango Local Database(SQL CE)" series of short posts that will cover all you need to know in order  to get started using a Local Database in Windows Phone 7.1 Mango.  This time I am going to talk about using the [Table] attribute when working with Local Database (SQL CE) in Windows Phone 7.1 Mango.

Here is what else is included in this series:

• Windows Phone Mango Local Database(SQL CE): Introduction
• Windows Phone Mango Local Database(SQL CE): Linq to SQL
• Windows Phone Mango Local Database(SQL CE): [Table] attribute
• Windows Phone Mango Local Database(SQL CE): [Column] attribute
• Windows Phone Mango Local Database(SQL CE): [Association] attribute
• Windows Phone Mango Local Database(SQL CE): [Index] attribute
• Windows Phone Mango Local Database(SQL CE): Database mapping
• Windows Phone Mango Local Database(SQL CE): DataContext
• Windows Phone Mango Local Database(SQL CE): Connection Strings
• Windows Phone Mango Local Database(SQL CE): Creating the Database
• Windows Phone Mango Local Database(SQL CE): Database Queries with LINQ
• Windows Phone Mango Local Database(SQL CE): How to Insert data
• Windows Phone Mango Local Database(SQL CE): How to Update data
• Windows Phone Mango Local Database(SQL CE): How to Delete data

To begin with, lets first mention that basically the local database functionality in Windows Phone 7.1 is an implementation of SQL Compact for Mango. You access the data stored in a local database using LINQ to SQL.

What is [Table] attribute?

Basically you can use this attribute to designate a class as an entity class that is associated with a database table or view. LINQ to SQL treats classes that have this attribute as persistent classes.

You can use the Name property of the TableAttribute attribute to specify a name for the table, and you can optionally use the schema name to qualify a table name. If you do not specify a name by using the Name property, the table name is assumed to be the same as the class name.

In addition to associating classes to tables you will need to denote each field or property you intend to associate with a database column.

NOTE: LINQ to SQL supports only single-table mapping. That is, an entity class must be mapped to exactly one database table, and you cannot map a database table to multiple classes at the same time.

How to use [Table] attribute?

Example1: Table with Name

[Table(Name = "Countries")]
public class Country
{
    //class contents here
}

Example2: Table without Name

[Table]
public class Country
{
    //class contents here
}

In this article I talked about using [Table] attribute when working with Windows Phone Mango Local Database(SQL CE). Stay tuned for the rest of the posts.

You can also follow us on Twitter @winphonegeek

Comments

Add comment to 'Windows Phone Mango Local Database(SQL CE): [Table] attribute'

Title Your Name

Comment