public bool StateProvinceDelete(StateProvince stateprovince)
        {
            return Execute<bool>(dal =>
            {
                StateProvince stateprovinceDelete = dal.StateProvince.Where(x => x.StateProvinceID == stateprovince.StateProvinceID).FirstOrDefault();
                if (stateprovinceDelete != null)
                {
                    dal.StateProvince.DeleteOnSubmit(stateprovinceDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool StateProvinceUpdate(StateProvince stateprovince)
        {
            return Execute<bool>(dal =>
            {
                StateProvince stateprovinceUpdate = dal.StateProvince.Where(x => x.StateProvinceID == stateprovince.StateProvinceID).FirstOrDefault();
                if (stateprovinceUpdate != null)
                {
                    stateprovinceUpdate.StateProvinceID = stateprovince.StateProvinceID;
                    stateprovinceUpdate.StateProvinceCode = stateprovince.StateProvinceCode;
                    stateprovinceUpdate.CountryRegionCode = stateprovince.CountryRegionCode;
                    stateprovinceUpdate.IsOnlyStateProvinceFlag = stateprovince.IsOnlyStateProvinceFlag;
                    stateprovinceUpdate.Name = stateprovince.Name;
                    stateprovinceUpdate.TerritoryID = stateprovince.TerritoryID;
                    stateprovinceUpdate.rowguid = stateprovince.rowguid;
                    stateprovinceUpdate.ModifiedDate = stateprovince.ModifiedDate;

                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
		private void detach_StateProvinces(StateProvince entity)
		{
			this.SendPropertyChanging();
			entity.SalesTerritory = null;
		}
		private void detach_StateProvinces(StateProvince entity)
		{
			this.SendPropertyChanging();
			entity.CountryRegion = null;
		}
 partial void DeleteStateProvince(StateProvince instance);
 partial void UpdateStateProvince(StateProvince instance);
 partial void InsertStateProvince(StateProvince instance);
 public void StateProvinceUpdate(StateProvince stateprovince)
 {
     adventureWorks_BC.StateProvinceUpdate(stateprovince);
 }
 public void StateProvinceAdd(StateProvince stateprovince)
 {
     adventureWorks_BC.StateProvinceAdd(stateprovince);
 }