SQL Metal在生成Windows Phone数据库-阿里云开发者社区

如果在winsows phone中使用数据库，可以使用SQLMetal，它不但能把SQL Server中的数据生成实体应用在WP中，还可以很方便的使用Linq来对数据库各实体进行操作。可以说是手机开发与桌面及web开发实现无缝的开发体验。

1、创建 SQL 数据库

2、把 SQL 库导成实体 CSharp 源代码

安装完WP开发环境后，会在安装路径下安装一个工具sqletal，这个工具可以帮助我们把SQL Server数据库转换成WP中应用的CSharp源代码。

在cmd命令下键入：

C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin>sqlmetal /server:. /database:accou

nt_db /namespace:test /code:f:/test.cs /language:csharp

server：指sql server服务器名

database：数据库名

namespace：生成的命名空间

code：生成源代码的路径和文件名

language：生成的语言

生成的源码如下：

#pragma warning disable 1591
namespace test
{
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Data;
using System.Collections.Generic;
using System.Reflection;
using System.Linq;
using System.Linq.Expressions;
using System.ComponentModel;
using System;
[System.Data.Linq.Mapping.DatabaseAttribute(Name="account_db")]
public partial class Account_db : System.Data.Linq.DataContext
{
private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
#region Extensibility Method Definitions
partial void OnCreated();
partial void InsertAccounts(Accounts instance);
partial void UpdateAccounts(Accounts instance);
partial void DeleteAccounts(Accounts instance);
partial void InsertItems(Items instance);
partial void UpdateItems(Items instance);
partial void DeleteItems(Items instance);
#endregion
public Account_db(string connection) :
base(connection, mappingSource)
{
OnCreated();
}
public Account_db(System.Data.IDbConnection connection) :
base(connection, mappingSource)
{
OnCreated();
}
public Account_db(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public Account_db(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public System.Data.Linq.Table<Accounts> Accounts
{
get
{
return this.GetTable<Accounts>();
}
}
public System.Data.Linq.Table<Items> Items
{
get
{
return this.GetTable<Items>();
}
}
}
[Table(Name="dbo.Accounts")]
public partial class Accounts : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _ID;
private System.Nullable<decimal> _Amount;
private System.Nullable<System.DateTime> _Dtime;
private System.Nullable<int> _ItemID;
private EntityRef<Items> _Items;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnIDChanging(int value);
partial void OnIDChanged();
partial void OnAmountChanging(System.Nullable<decimal> value);
partial void OnAmountChanged();
partial void OnDtimeChanging(System.Nullable<System.DateTime> value);
partial void OnDtimeChanged();
partial void OnItemIDChanging(System.Nullable<int> value);
partial void OnItemIDChanged();
#endregion
public Accounts()
{
this._Items = default(EntityRef<Items>);
OnCreated();
}
[Column(Storage="_ID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int ID
{
get
{
return this._ID;
}
set
{
if ((this._ID != value))
{
this.OnIDChanging(value);
this.SendPropertyChanging();
this._ID = value;
this.SendPropertyChanged("ID");
this.OnIDChanged();
}
}
}
[Column(Storage="_Amount", DbType="Money")]
public System.Nullable<decimal> Amount
{
get
{
return this._Amount;
}
set
{
if ((this._Amount != value))
{
this.OnAmountChanging(value);
this.SendPropertyChanging();
this._Amount = value;
this.SendPropertyChanged("Amount");
this.OnAmountChanged();
}
}
}
[Column(Storage="_Dtime", DbType="DateTime")]
public System.Nullable<System.DateTime> Dtime
{
get
{
return this._Dtime;
}
set
{
if ((this._Dtime != value))
{
this.OnDtimeChanging(value);
this.SendPropertyChanging();
this._Dtime = value;
this.SendPropertyChanged("Dtime");
this.OnDtimeChanged();
}
}
}
[Column(Storage="_ItemID", DbType="Int")]
public System.Nullable<int> ItemID
{
get
{
return this._ItemID;
}
set
{
if ((this._ItemID != value))
{
if (this._Items.HasLoadedOrAssignedValue)
{
throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();
}
this.OnItemIDChanging(value);
this.SendPropertyChanging();
this._ItemID = value;
this.SendPropertyChanged("ItemID");
this.OnItemIDChanged();
}
}
}
[Association(Name="FK_Accounts_Items", Storage="_Items", ThisKey="ItemID", OtherKey="ID", IsForeignKey=true)]
public Items Items
{
get
{
return this._Items.Entity;
}
set
{
Items previousValue = this._Items.Entity;
if (((previousValue != value)
|| (this._Items.HasLoadedOrAssignedValue == false)))
{
this.SendPropertyChanging();
if ((previousValue != null))
{
this._Items.Entity = null;
previousValue.Accounts.Remove(this);
}
this._Items.Entity = value;
if ((value != null))
{
value.Accounts.Add(this);
this._ItemID = value.ID;
}
else
{
this._ItemID = default(Nullable<int>);
}
this.SendPropertyChanged("Items");
}
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
}
[Table(Name="dbo.Items")]
public partial class Items : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _ID;
private string _ItemName;
private EntitySet<Accounts> _Accounts;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnIDChanging(int value);
partial void OnIDChanged();
partial void OnItemNameChanging(string value);
partial void OnItemNameChanged();
#endregion
public Items()
{
this._Accounts = new EntitySet<Accounts>(new Action<Accounts>(this.attach_Accounts), new Action<Accounts>(this.detach_Accounts));
OnCreated();
}
[Column(Storage="_ID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int ID
{
get
{
return this._ID;
}
set
{
if ((this._ID != value))
{
this.OnIDChanging(value);
this.SendPropertyChanging();
this._ID = value;
this.SendPropertyChanged("ID");
this.OnIDChanged();
}
}
}
[Column(Storage="_ItemName", DbType="NVarChar(50)")]
public string ItemName
{
get
{
return this._ItemName;
}
set
{
if ((this._ItemName != value))
{
this.OnItemNameChanging(value);
this.SendPropertyChanging();
this._ItemName = value;
this.SendPropertyChanged("ItemName");
this.OnItemNameChanged();
}
}
}
[Association(Name="FK_Accounts_Items", Storage="_Accounts", ThisKey="ID", OtherKey="ItemID", DeleteRule="NO ACTION")]
public EntitySet<Accounts> Accounts
{
get
{
return this._Accounts;
}
set
{
this._Accounts.Assign(value);
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
private void attach_Accounts(Accounts entity)
{
this.SendPropertyChanging();
entity.Items = this;
}
private void detach_Accounts(Accounts entity)
{
this.SendPropertyChanging();
entity.Items = null;
}
}
}
#pragma warning restore 1591

3、把 SQL 实体代码添加到项目中

A. 添加项目引用System.Data.Linq

B. 注释掉用System.Data.IDbConnection的构造函数，因为在WP中没有IDbConnection接口

C. 保持数据库实体对象中，表集合的命名是复数形式（注意是Account_db类中），即Accounts和Items

D. 实体类Table特性类的Name属性不要带dbo，如下：

[ Table(Name="dbo.Accounts")]改成[ Table(Name="Accounts")]

E. 实体类中的属性如果是string类型，最好用Column特性的DbType命名参数用NVarchar，如下：[ Column(Storage="_ItemName", DbType="NVarChar(50)")]

4、在 Windows Phone 下生成数据库

可以在App类的Application_Launching事件方法中写入如下代码来创建WP中的数据库对象：

using (Test.Account_db db = new Account_db("Data Source='isostore:/test.sdf';Password=123"))
{
if (db.DatabaseExists() == false)
{
db.CreateDatabase();
}
}

5、 操作数据

操作数据的方法与 web和桌面开发是相同的，使用Linq To SQL方法即可。下面是Items实体对象的添加。

Account_db accountdb = new Account_db("Data Source='isostore:/test.sdf';Password='saiko2011'");
Items item = new Items();
item.ItemName = "收入";
accountdb.Items.InsertOnSubmit(item);
accountdb.SubmitChanges();
lb.ItemsSource = accountdb.Items;

本文转自桂素伟51CTO博客，原文链接：http://blog.51cto.com/axzxs/762688 ，如需转载请自行联系原作者

SQL Metal在生成Windows Phone数据库

热门文章

最新文章

相关课程

相关电子书

相关实验场景