public bool AddPlate(Plate plate) { if (plate == null) { return(false); } _plates.Add(plate); return(true); }
const string ConnectionString = @"Server=(localdb)\MSSQLLocalDB;Database=EmployeeDbDev;Trusted_Connection=True;MultipleActiveResultSets=true";//"Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=myTestDB;Data Source=ANKIT-HP\\SQLEXPRESS"; public int AddPlate(Plate plate) { if (plate == null) { return(0); } try { using (var connection = new SqlConnection(ConnectionString)) { var insertedPlate = connection.QuerySingle <Plate>("spAddPlate", new{ plate.Name, plate.MinCharacters, plate.MaxCharacters }, commandType: System.Data.CommandType.StoredProcedure); return(insertedPlate.Id); } } catch (Exception ex) { } return(-1); }