check if record exist

Discussion in 'ASP .Net' started by Seema, Jun 8, 2009.

  1. Seema

    Seema Guest

    What is the best way to check for a record exists in a database using linq to
    sql?
    I want to check if a userid (int) and typeid (int) exist. - The following
    code always returns zero even if the record exists - what is the best
    approach?

    int result = 0
    result = (from t in context.customers
    where ((t.userid == intUserID) && (t.typeid ==
    intTypeID))
    select t).Count();
     
    Seema, Jun 8, 2009
    #1
    1. Advertising

  2. On Jun 8, 6:33 am, Seema <> wrote:
    > What is the best way to check for a record exists in a database using linq to
    > sql?
    > I want to check if a userid (int) and typeid (int)  exist. - The following
    > code always returns zero even if the record exists - what is the best
    > approach?
    >
    > int result = 0
    > result = (from t in context.customers
    >                               where ((t.userid == intUserID) && (t.typeid ==
    >  intTypeID))
    >                               select t).Count();


    var v = from t in context.customers where t.userid == intUserID &&
    t.typeid == intTypeID select t;
    bool exists = v.Count() == 0 ? false : true;
     
    Alexey Smirnov, Jun 8, 2009
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page