Linq IQueryable variables

Posted by kevinw on Stack Overflow See other posts from Stack Overflow or by kevinw
Published on 2009-08-26T08:54:19Z Indexed on 2010/03/14 4:05 UTC
Read the original article Hit count: 681

Filed under:
|
|

Hi i have a function that should return me a string but what is is doing is bringing me back the sql expression that i am using on the database what have i done wrong

 public static IQueryable XMLtoProcess(string strConnection)
    {
        Datalayer.HameserveDataContext db = new HameserveDataContext(strConnection);

        var xml = from x in db.JobImports
                  where x.Processed == false
                  select new { x.Content };
        return xml;

    }

this is the code sample

this is what i should be getting back

<PMZEDITRI TRI_TXNNO="11127" TRI_TXNSEQ="1" TRI_CODE="600" TRI_SUBTYPE="1" TRI_STATUS="Busy" TRI_CRDATE="2008-02-25T00:00:00.0000000-00:00" TRI_CRTIME="54540" TRI_PRTIME="0" TRI_BATCH="" TRI_REF="" TRI_CPY="main" C1="DEPL" C2="007311856/001" C3="14:55" C4="CUB2201" C5="MR WILLIAM HOGG" C6="CS12085393" C7="CS" C8="Blocked drain" C9="Scheme: CIS Home Rescue edi tests" C10="MR WILLIAM HOGG" C11="74 CROMARTY" C12="OUSTON" C13="CHESTER LE STREET" C14="COUNTY DURHAM" C15="" C16="DH2 1JY" C17="" C18="" C19="" C20="" C21="CIS" C22="0018586965 ||" C23="BD" C24="W/DE/BD" C25="EX-DIRECTORY" C26="" C27="/" C28="CIS Home Rescue" C29="CIS Home Rescue Plus Insd" C30="Homeserve Claims Management Ltd|Upon successful completion of this repair the contractor must submit an itemised and costed Homeserve Claims Management Ltd Job Sheet." N1="79.9000" N2="68.0000" N3="11.9000" N4="0" N5="0" N6="0" D1="2008-02-25T00:00:00.0000000-00:00" T2="EX-DIRECTORY" T4="Blocked drain" TRI_SYSID="9" TRI_RETRY="3" TRI_RETRYTIME="0" />

can anyone help me please

© Stack Overflow or respective owner

Related posts about web-services

Related posts about Xml