«

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();

On Jun 8, 6:33*am, Seema <Se...@discussions.microsoft.com> 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;