public virtual CustomerSession UpdateCustomerSession(CustomerSession entity) { if (entity.IsTransient()) { return(entity); } CustomerSession other = GetCustomerSession(entity.CustomerSessionId); if (entity.Equals(other)) { return(entity); } string sql = @"Update CustomerSession set [CustomerID]=@CustomerID , [SessionName]=@SessionName , [SessionValue]=@SessionValue , [ipaddr]=@ipaddr , [LastActivity]=@LastActivity , [LoggedOut]=@LoggedOut , [CustomerSessionGUID]=@CustomerSessionGUID , [CreatedOn]=@CreatedOn , [ExpiresOn]=@ExpiresOn where CustomerSessionID=@CustomerSessionID" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@CustomerSessionID", entity.CustomerSessionId) , new SqlParameter("@CustomerID", entity.CustomerId) , new SqlParameter("@SessionName", entity.SessionName) , new SqlParameter("@SessionValue", entity.SessionValue ?? (object)DBNull.Value) , new SqlParameter("@ipaddr", entity.Ipaddr ?? (object)DBNull.Value) , new SqlParameter("@LastActivity", entity.LastActivity) , new SqlParameter("@LoggedOut", entity.LoggedOut ?? (object)DBNull.Value) , new SqlParameter("@CustomerSessionGUID", entity.CustomerSessionGuid) , new SqlParameter("@CreatedOn", entity.CreatedOn) , new SqlParameter("@ExpiresOn", entity.ExpiresOn) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetCustomerSession(entity.CustomerSessionId)); }