Hi,
I am new to LINQ and was wondering how I would write the following SQL query in LINQ
SELECT Sum(totalTendered)
FROM Batch
Where convert(varchar,LastUpdated,101) = '11/01/2007'
Thanks
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Studio_.NET_2005/Q_23013...
How do I create dynamic query in link. I have dropdown list and search text box , if dropdown list > 0 then I want to append this to linq query
Thank you
http://www.experts-exchange.com/Microsoft/Development/.NET/Q_23568923.html
MVP.Models.IZone IZ = new LinqUtilityWellView.wvt_wvZone();
//Clearly wvt_wvZone implements IZone. but for some reason the following line does not compile
IEnumerable<MVP.Models.IZone> blah = (I...
http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/Q_23575204.h...
If query one table in linq to sql; how can I check if one fileld (an image field set to binary in dbml) is null or empty.
So say something like this
var results = from p in mycontext
...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_23796521.html
Zones:
.NET,
LINQDate Answered: 10/08/2008 Grade: A Views: 90
I am trying to append/join 2 Linq to SQL querys but am getting the following error:
Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<AnonymousType#1>' to 'System.Data.Enume...
http://www.experts-exchange.com/Programming/Languages/.NET/LINQ/Q_23796949.html
Hello -
I am trying to verify if a duplicate value is entered in my datagridview , so I try to count how many records with the same value I already have in my database. The linq code is not wo...
http://www.experts-exchange.com/Programming/Languages/.NET/LINQ/Q_23733665.html
I know there have been many creative solutions to the problem where the Gridview does not display its headers unless at least one row is bound but I need one for use with Linq.
I was looking at ...
http://www.experts-exchange.com/Programming/Languages/.NET/LINQ/Q_23400288.html
I m using datalist in my application and i m binding datalist with lisq to sql
liqdatacontext db=new linqdatacontext();
var products=from p in db.products where p.productid>0 select p;
datalis...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_23501403.htm...
i have array like
string[] email=new string[]{"aa@aa.com","aa1@aa.com"}
now i need to extract all record which does not contail this emails.
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Studio_.NET_2005/Q_23504...
I have a database table that lists product categories and sub categories as follows
Products table.............
*producttable*
id
p...
http://www.experts-exchange.com/Database/Miscellaneous/Q_23805495.html