Code that does work:
public
IQueryable<V_SWGS_Sites_All> GetSWGSSitesVDelta(NERC_CIP_DomainModel context,
string
customerName)
{
IQueryable<V_SWGS_Sites_All> vSites = (from vs
in
context.V_SWGS_Sites_Alls
where vs.CustomerName == customerName
&& !(from s
in
context.Sites
select s.SourceSiteId).Contains(vs.SiteID)
select vs);
return
vSites;
}
Code I am trying to impliment that does not work:
public
object
GetCustomerContactDropDown(NERC_CIP_DomainModel context,
int
customerId,
int
siteId)
{
var custContact = (from cc
in
context.CustomerContacts
where cc.CustomerId == customerId
&& !(from cs
in
context.CustomerSites
join csc
in
context.CustomerSiteContacts
on cs.CustomerSiteId equals csc.CustomerSiteId
where cs.SiteId == siteId
select csc.CustomerContactId).Contains(cc.CustomerContactId)
select
new
{
cc.CustomerContactId,
name = cc.FirstName +
" "
+ cc.LastName
});
return
custContact;
}
Below is the error message i am getting:
Message: An exception occured during the execution of ' Extent.Where(cc => ((cc.CustomerId = value(Siemens.Energy.ASP.NERCCIP.Data.CustomerContact+<>c__DisplayClassf).customerId) && Not(value(Siemens.Energy.ASP.NERCCIP.Data.CustomerContact+<>c__DisplayClassf).context.CustomerSites.Join(value(Siemens.Energy.ASP.NERCCIP.Data.CustomerContact+<>c__DisplayClassf).context.CustomerSiteContacts, cs => cs.CustomerSiteId, csc => csc.CustomerSiteId, (cs, csc) => new <>f__AnonymousType4`2(cs = cs, csc = csc)).Where(<>h__TransparentIdentifierc => (<>h__TransparentIdentifierc.cs.SiteId = value(Siemens.Energy.ASP.NERCCIP.Data.CustomerContact+<>c__DisplayClassf).siteId)).Select(<>h__TransparentIdentifierc => <>h__TransparentIdentifierc.csc.CustomerContactId).Contains(cc.CustomerContactId)))).Select(cc => new <>f__AnonymousType3`2(CustomerContactId = cc.CustomerContactId, name = ((cc.FirstName + " ") + cc.LastName)))'. See InnerException for more details. .
Source: Telerik.OpenAccess.35.Extensions.
Stack Trace: at Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQuery(Type type, Int32 elementAt, Object[] groupResolutionParamValues) at Telerik.OpenAccess.Query.ExpressionExecution.PerformDatabaseQuery[T](Piece`1 piece, Object[] grpVals) at Telerik.OpenAccess.Query.Piece`1.System.Collections.IEnumerable.GetEnumerator() at Telerik.Web.UI.ControlDataBinder.BindToEnumerableData(IEnumerable dataSource) at Telerik.Web.UI.ControlItemContainer.PerformDataBinding(IEnumerable data) at Telerik.Web.UI.RadComboBox.PerformDataBinding(IEnumerable dataSource) at Telerik.Web.UI.RadComboBox.OnDataSourceViewSelectCallback(IEnumerable data) at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) at Telerik.Web.UI.RadComboBox.OnDataBinding(EventArgs e) at Telerik.Web.UI.RadComboBox.PerformSelect() at System.Web.UI.WebControls.BaseDataBoundControl.DataBind() at Telerik.Web.UI.RadComboBox.DataBind() at SiteEdit.rg_Site_SelectedIndexChanged(Object sender, EventArgs e) in c:\Documents and Settings\helwi00s\My Documents\Visual Studio 2008\Projects\NERC_CIP\NERC_CIP\Pages\SiteEdit.aspx.cs:line 124
Inner Exception: System.NullReferenceException: Object reference not set to an instance of an object. at Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQueryImpl(Type type, Int32 elementAt, Object[] groupResolutionParamValues) at Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQuery(Type type, Int32 elementAt, Object[] groupResolutionParamValues)