SilverLight中使用数据服务对数据库CRUD

冷不防 2022-08-07 12:51 30阅读 0赞

1．建立一个数据模型

注意：模型对应的表一定要有主键，否则，建立时将不会成功。

2.建立一个数据服务

publicclass WebDataService1 : DataService<myDBEntities>

// 仅调用此方法一次以初始化涉及服务范围的策略。

public static void InitializeService(IDataServiceConfiguration config)

// TODO: 设置规则以指明哪些实体集和服务操作是可见的、可更新的，等等。

config.SetEntitySetAccessRule("\*", EntitySetRights.All);

config.SetServiceOperationAccessRule("\*", ServiceOperationRights.All);

\[WebGet\]

public IQueryable<tabA> getTabA(string a)

var v = CurrentDataSource.tabA.Where(p => p.a == a);

return v;

\[WebInvoke\]

public IQueryable<tabX> getTabX(string x)

var v = CurrentDataSource.tabX.Where(p => p.x == x);

return v;

\[QueryInterceptor("tabX")\]

public System.Linq.Expressions.Expression<Func<tabX, bool>> query\_tabX()

return p => p.z != "wwxxdd"; //为真表示允许查询

\[ChangeInterceptor("tabX")\]

public void change\_tabX(tabX en, UpdateOperations operation)

//-

if (operation == UpdateOperations.Add)

if (string.IsNullOrEmpty(en.y))

//如果\[y\]为空的处理代码

//-

if (operation == UpdateOperations.Change)

//-

if (operation == UpdateOperations.Delete)

3.设置xaml页面

<data:DataGrid x:Name="dg"></data:DataGrid>

</StackPanel>

4.在xaml页面对应的cs文件中添加代码

public MainPage()

InitializeComponent();

this.spTool.Loaded += new RoutedEventHandler(spTool\_Loaded);

this.btnRetrivebyWeb.Click += new RoutedEventHandler(btnRetrivebyWeb\_Click);

this.btnRetriveByService.Click += new RoutedEventHandler(btnRetriveByService\_Click);

this.btnCreate.Click += new RoutedEventHandler(btnCreate\_Click);

this.btnUpdate.Click += new RoutedEventHandler(btnUpdate\_Click);

this.btnDelete.Click += new RoutedEventHandler(btnDelete\_Click);

\#region WebClient方式加载数据

private void btnRetrivebyWeb\_Click(object sender, RoutedEventArgs e)

Uri uri = new Uri("http://localhost:8081/WebDataService1.svc/tabA");

WebClient client = new WebClient();

client.OpenReadCompleted += new OpenReadCompletedEventHandler(client\_completed);

client.OpenReadAsync(uri);

void client\_completed(object sender, OpenReadCompletedEventArgs e)

if (e.Error == null)

XmlReader reader = XmlReader.Create(e.Result);

XDocument ls = XDocument.Load(reader);

XNamespace xmlns = "http://www.w3.org/2005/Atom";

XNamespace d = "http://schemas.microsoft.com/ado/2007/08/dataservices";

XNamespace m = "http://schemas.microsoft.com/ado/2007/08/dataservices/metadata";

var list = from x in ls.Descendants(xmlns + "entry")

select new myService.tabA

a = x.Descendants(d + "a").First().Value,

b = x.Descendants(d + "b").First().Value,

c = x.Descendants(d + "c").First().Value

\};

dg.ItemsSource = list;

\#endregion

//--------------------------------------------------------------------------------------

myService.myDBEntities server;

private void spTool\_Loaded(object sender, RoutedEventArgs e)

Uri url = new Uri("http://localhost:8081/WebDataService1.svc");

server = new myService.myDBEntities(url);

\#region DataServiceContext方式加载数据

private void btnRetriveByService\_Click(object sender, RoutedEventArgs e)

Uri urlE = new Uri("http://localhost:8081/WebDataService1.svc/tabX");

server.BeginExecute<myService.tabX>(urlE, new AsyncCallback(load\_completed), null);

void load\_completed(IAsyncResult obj)

var tp = server.EndExecute<myService.tabX>(obj);

this.dg.ItemsSource = tp.ToList();

\#endregion

void saveChanges\_completed(IAsyncResult obj)

if (obj.IsCompleted)

//新增后,立即调用btnRetriveByService\_Click时,会出错。

btnRetriveByService\_Click(null, new RoutedEventArgs());

\#region添加数据并保存

private void btnCreate\_Click(object sender, RoutedEventArgs e)

server.AddTotabX(new myService.tabX() \{ x = "007", z = "sss", y = "sss" \});

server.BeginSaveChanges(new AsyncCallback(saveChanges\_completed), null);

\#endregion

\#region修改数据并保存

private void btnUpdate\_Click(object sender, RoutedEventArgs e)

Uri urlE = new Uri("http://localhost:8081/WebDataService1.svc/tabX");

server.BeginExecute<myService.tabX>(urlE, new AsyncCallback(begin\_edit), null);

void begin\_edit(IAsyncResult obj)

var tp = server.EndExecute<myService.tabX>(obj).Where(p => p.x == "007").First();

tp.y = "hello";

server.UpdateObject(tp);

server.BeginSaveChanges(new AsyncCallback(saveChanges\_completed), null);

\#endregion

\#region删除数据并保存

private void btnDelete\_Click(object sender, RoutedEventArgs e)

Uri urlE = new Uri("http://localhost:8081/WebDataService1.svc/tabX");

server.BeginExecute<myService.tabX>(urlE, new AsyncCallback(begin\_del), null);

void begin\_del(IAsyncResult obj)

var tp = server.EndExecute<myService.tabX>(obj).Where(p => p.x == "007").First();

server.DeleteObject(tp);

server.BeginSaveChanges(new AsyncCallback(saveChanges\_completed), null);

\#endregion

SilverLight中使用数据服务对数据库CRUD

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关使用Java的JDBC对数据库进行CRUD操作示例

相关 NodeJs——对数据库CRUD

相关在Silverlight中使用定时器（Timer）

相关 hibernate对数据库进行CRUD操作

相关 SilverLight中使用WebService对数据库做CRUD

相关 SilverLight中使用数据服务对数据库CRUD

相关 SilverLight中数据与通信之ASMX

相关 SilverLight中数据与通信之WebClient

相关 silverlight教程 silverlight 数据绑定

相关 Silverlight 中 TreeView 的数据绑定