开发者

How to implement a Query with IQueryable in SilverLight

开发者 https://www.devze.com 2022-12-09 01:54 出处:网络
I have two tables customers, pay and want to implement a gr开发者_JAVA百科idview in silverlight with the outcome of the relationship of these two tables, the query is as follows

I have two tables customers, pay and want to implement a gr开发者_JAVA百科idview in silverlight with the outcome of the relationship of these two tables, the query is as follows

SELECT     Pa.Tipo_Pagare, Pa.Pagare, Pa.Rut, Cli.Nombre
FROM         Cred_Crexsa.dbo.Pagare AS Pa INNER JOIN
                  Cred_Crexsa.dbo.Clientes AS Cli ON Pa.Rut = Cli.Rut
WHERE     (Pa.Nulo <> 0) AND (Pa.Extraviado <> 0)

Thank you very much Leonardo Moreno Flores


Silverlight doesn't have any DB libraries. You'll need to write a webservice. Either reconstruct the query on the web server using your ORM of choice (many of them now support LINQ features, if you prefer) or have it call a stored procedure based on the SQL you posted.

0

精彩评论

暂无评论...
验证码 换一张
取 消