如何将转换查询sql转换为linq转换为sql [英] how to make convert query sql to linq to sql

问题描述

我是linq的新手我想知道我的查询是否正确



这是我在sql中的查询服务器

i'm new in linq i want to know if my query is true

this is my query in sql server

select s.LIBELE_STATION,na.LIBELE_NA,sa.SEUIL_ALERTE
from NIVEAU_ALERTE na, ALARME_STATION sa, PARAMETRE_MESURE pm , STATION s
where sa.ID_NA=na.ID_NA
and sa.ID_PM=pm.ID_PM
and sa.ID_STATION=s.ID_STATION
and s.ID_STATION='Ain Sebou'
and pm.LIBELE_PM='Niveau'

和linq

and in linq

var alar = from sa in context.ALARME_STATION
                              join na in context.NIVEAU_ALERTE on sa.ID_NA equals na.ID_NA
                              join pm in context.PARAMETRE_MESURE on sa.ID_PM equals pm.ID_PM
                              join s in context.STATIONs on sa.ID_STATION equals s.ID_STATION
                              where pm.LIBELE_PM == val && s.ID_STATION == drp_state.SelectedValue
                              select new
                              {
                                  libel = pm.LIBELE_PM,
                                  na = na.LIBELE_NA,
                                  seul = sa.SEUIL_ALERTE
                              };

如果是，为什么我有错误显示在图片中



http://www.mediafire.com/view/4gdm1xnwal8is9c/code2.png [< a href =http://www.mediafire.com/view/4gdm1xnwal8is9c/code2.pngtarget =_ blanktitle =New Window> ^ ]



i希望将gridview绑定为我的代码apear

if yes why i have error wich is display in pic

http://www.mediafire.com/view/4gdm1xnwal8is9c/code2.png[^]

i want to bind gridview as my code apear

推荐答案

引用：

谢谢你现在的工作我改变了我的网格视图的id，因为在我的webform中我有2个网格，我绑定了第一个现在它工作，感谢很多

thank you it work now i change id of my grid view because in my webform i have 2 grid and i bind the first one now it works thanks o lot

添加以关闭线程。

这篇关于如何将转换查询sql转换为linq转换为sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！