I have a boolean column in my database called HasEvent
that has a constraint of not-null. When I try to add an item to the table via POST request and HasEvent
is false, it is translated to null, and I get this error:
Npgsql.PostgresException (0x80004005): 23502: null value in column "HasEvent" violates not-null constraint
The data is showing up as it should. What could be happening?
PS: When I try to update an item already created and set its HasEvent
value to false via PUT request, I get no error.
Here is my code:
Entity:
public class Period
{
public long Id { get; set; }
public DateTime InitialDate { get; set; }
public DateTime? FinalDate { get; set; }
public bool HasEvent { get; set; }
}
Controller:
[HttpPost]
public ActionResult<Period> Create(Period createPeriod)
{
if (ModelState.IsValid)
{
try
{
var period = Service.Post(createPeriod);
return Created("Created", period);
}
catch (Exception e)
{
return BadRequest(e);
}
}
return BadRequest();
}
Method:
public Period Post(Period period)
{
PeriodsRepository.Create(period);
return period;
}
EDIT: Repository:
public interface PeriodsRepository<TEntity> : IDisposable where TEntity : class, new()
{
IQueryable<TEntity> SelectAll { get; }
TEntity Select(long key);
void Create(params TEntity[] obj);
void Update(params TEntity[] obj);
void Delete(params TEntity[] obj);
}
User contributions licensed under CC BY-SA 3.0