static void Main(string[] args)
{
using (var reproContext = new ReproContext())
{
reproContext.Database.Migrate();
var testDate = new DateTime(2018, 10, 07);
// just to assert regular query is working fine
{
var findASingleRecord = reproContext.ReproEntity
.FirstOrDefault(a => a.MyTime == testDate);
Console.WriteLine($"Found record is null: {findASingleRecord == null}.");
}
// now lets test the problematic query
var testDateList = new List <DateTime>()
{
testDate
};
try
{
// this will fail
var findRecordsWithDateInList = reproContext.ReproEntity
.Where(a => testDateList.Contains(a.MyTime))
.ToList();
Console.WriteLine($"Loaded {findRecordsWithDateInList.Count} entities from ReproEntity.");
}
catch (Exception e)
{
Console.WriteLine($"\nBUG? Query on ReproEntity failed: {e}\n");
}
// just to be sure that the problem is in 'smalldatetime' column type, we run the same code vs another entity with regular column type
try
{
// this won't fail
var findRecordsWithDateInList = reproContext.WorkingEntity
.Where(a => testDateList.Contains(a.MyTime))
.ToList();
Console.WriteLine($"Loaded {findRecordsWithDateInList.Count} entities from WorkingEntity.");
}
catch (Exception e)
{
Console.WriteLine($"\nQuery on ReproEntity failed: {e}\n"); // this won't happen
}
// not sure why, but using constant DateTime in any kind of query will also trigger the same error
// this is the same query as above but with constant parameter (no query parametrization)
try
{
var findASingleRecord = reproContext.ReproEntity
.FirstOrDefault(a => a.MyTime == new DateTime(2018, 10, 07));
Console.WriteLine($"Found record is null: {findASingleRecord == null}.");
}
catch (Exception e)
{
Console.WriteLine($"\nQuery which worked above also failed: {e}\n");
}
}
}
public ThingTypeController(ReproContext context, IMapper mapper)
{
this.context = context;
this.mapper = mapper;
}
public EventsController(ReproContext reproContext, IMapper mapper)
{
_reproContext = reproContext;
_mapper = mapper;
}
