store procedure with return type table in linq

use

SET FMTONLY OFF
in SQL store procedure and following in LINQ code

var MemDetailsOrdered = DataContext.GetOrderedElig(param1,param2,param..).ToList()

other wise it will return default int type

Online Trading sites

scottrage
TradeKing

good site for health

Good site for health

CLICK HERE

please explore

Credit Card be safe

real store from one thief

CLICK HERE


Beware before using Credit Cards

Best Business School - 2010

Best Business School - 2010

Click here

MBA - Business

Searching Gmail

Search into your Gmail

Click here


search any email or item from you gmail account

NULL condition in CASE statement

The following would NOT work

case when e.myCode = null then e.yourCode else e.myCode end as displayCode

instead use below

,isnull(e.myCode,e.yourCode) as displayCode



hope this helps