Recently I developed a website that was built with WebMatrix. The scenario required database interaction and I wanted to use SQL Compact in order to be more portable. But I didn’t want to use the classic way of accessing my data via SQL queries. So I...
Well maybe not for everyone but for me is definitely really important. That is why I get straight into the point. We have the following model: Which maps to the following database: We are using EF4.0 and we want to load all Burgers including BurgerDetails...
A quick tip about how to compare a datetime field in our database and to be extact only the Date part ignoring the time. Let’s say that we want to find all records that where created today: Where(@"Day(it.CreatedTime) == Day(CurrentDateTime()) AND...