forum

Home / DeveloperSection / Forums / how to validate validations whether textbox is empty or not. using linq to sql. in mvc

Ask Question

how to validate validations whether textbox is empty or not. using linq to sql. in mvc

venkat gosetty442818-Nov-2011
hi,
   how to validate validations whether textbox is empty or not. using linq to sql.

Regards,
Venkat
asp.net mvcasp.net mvc 
Updated on 22-Nov-2011
venkat gosetty

venkat gosetty

Follow

Can you answer this question?

Answer

3 Answers

Chris Anderson

Chris Anderson

22-Nov-2011
hi,

you can put validation using linq to sql query something like below:

DataContext data = new DataContext();
string value="S001";
var query = from p in data.Persons
                   where p.Id == 
value
                                  select p;

if (query.Count() > 0) throw new Exception("Id already exists in the database");

venkat gosetty

venkat gosetty

22-Nov-2011
Actually  i have taken model class .dbml (linq to sql template)
Chris Anderson

Chris Anderson

18-Nov-2011
hi venkat,

if you want validate your textbox, simply use:

namespace:
using System.ComponentModel.DataAnnotations;

and above the property add following:
[StringLength(50),Required]
public string Name { get; set; }

why you use linq to sql for validation?

Liked By