For demo I have created similar example. First I created Person class as model and Dummy database:
public class Person
{
public string Name { get; set; }
[DataType(DataType.EmailAddress)]
public string Email { get; set; }
public string Profession { get; set; }
public int Age { get; set; }
}
public class DummyDatabase
{
public List<Person> GetAllPersons()
{
return new List<Person> {
new Person () { Name = "Arti", Email = "arti@abc.com",
Profession = "Engineer", Age = 25},
new Person () { Name = "Deepak", Email = "deepak@gmail.com",
Profession = "Engineer", Age = 25}
};
}
}
Now In controller I am writing the method like:
public string CheckEmail(string email)
{
DummyDatabase db = new DummyDatabase();
var allPerson = db.GetAllPersons();
var result = (from p in allPerson
where p.Email == email select p).ToList();
if (result.Count > 0)
{
return "Exist";
}
else
{
return "Does not exist";
}
}
Hope it will help you to get an idea to implement in your code.
Use ADO.NET or Entity Framework to connect to database.
For Entity Framework go to:
Simple Sample with Entity Framework [
^]
and
http://msdn.microsoft.com/en-us/data/ee712907.aspx
For ADO.NET please visit:
Using ADO.NET for beginners[
^]