LINQ query C#, ASP.NET

Adding .any() and changing to bool is correct syntax wise. Thanks!

However, the issue is not resolved. I'm trying to verify whether a new user, while sign-up already exists in the database ('Login' table). Below is the code that I have written. However, it's not checking the 'textboxnewusername.Text' with the existing 'Username' in the 'Login table'. Any idea what to do? The 'Labelmessage' is not displayed in any case!

 

protected void Buttonsubmit_Click(object sender, EventArgs e)
{
using (ShopDataContext Data = new ShopDataContext())
{
Login newlogin = new Login();       //Creating instance of the 'Login' table//

var check = Data.Logins.Where(Login => Login.Username==TextBoxnewusername.Text);    //Lambda expression//

foreach (Login output in check)
{
if (output.Username != TextBoxnewusername.Text)
{
newlogin.Name = TextBoxname.Text;
newlogin.Username = TextBoxnewusername.Text;
newlogin.Address = TextBoxaddress.Text;
newlogin.password = TextBoxnewpassword.Text;

Data.Logins.InsertOnSubmit(newlogin);
Data.SubmitChanges();
Labelmessage.Text = "Successful";
}

else
{
Labelmessage.Text = "User name already exists in the database, pls. select a new username";
}

}
}
} 

Hi sayan

 

 

var result=Data.Logins.Where(Login=>Login.Username==TextBoxnewusername.Text).Any();