Give a solution for find existing email id in mvc project

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[^]