score:4

Accepted answer
 public tblopportunity getopportunitybycode(string clientcode, string opportunitycode)
    {
        tblopportunity opportunity = null;
        var convertedopportunitycode = convert.toint32(opportunitycode);
        connectionhandler.invoke<entityconnection>((connection) =>
        {
            var context = new dmsentities();
            opportunity = context.tblopportunities.firstordefault<tblopportunity>(o => o.clientcode == clientcode && o.opportunitycode == convertedopportunitycode);
        });

        return opportunity;
    }

score:1

public tblopportunity getopportunitybycode(
                          string clientcode, string opportunitycode)
{
    tblopportunity opportunity = null;

    var convertedopportunitycode = convert.toint32(opportunitycode);

    connectionhandler.invoke<entityconnection>((connection) =>
    {
        var context = new xxentities();
        opportunity = context.tblopportunities
                             .firstordefault(o =>
                                 o.clientcode == clientcode &&
                                 o.opportunitycode == convertedopportunitycode);
     });

     return opportunity;
 }

score:1

public tblopportunity getopportunitybycode(string clientcode, string opportunitycode) {
    tblopportunity opportunity = null;
    // do the conversion outside linq
    var opcodeint = convert.toint32(opportunitycode);
    connectionhandler.invoke<entityconnection>((connection) => {
        var context = new xxentities();
        opportunity = context.tblopportunities.firstordefault<tblopportunity>(
            o => o.clientcode == clientcode && o.opportunitycode == opcodeint
        ); //                                                       ^^^^^^^^^
    });
    return opportunity;
}

Related Query

More Query from same tag