public IList <T> GetAll()
{
using (var session = SessionFactory.Get())
{
return((from account in session.Query <T>()
select account).ToList());
}
}
public static void Reset()
{
var x =
new TimeWarpSessionFactory <TimeWarpUserStateClassMap>();
var query = GetQueryString();
using (var session = x.Get())
{
ISQLQuery sqlquery = session.CreateSQLQuery(query);
sqlquery.ExecuteUpdate();
}
}
static void Main(string[] args)
{
TimeWarpSessionFactory <TimeWarpUserStateClassMap> x = new TimeWarpSessionFactory <TimeWarpUserStateClassMap>();
var now = DateTime.UtcNow;
var sqlFormattedDate = now.ToString("yyyy-MM-dd HH:mm:ss");
string query =
string.Format("update UserState Set UserState.PeriodStartTime = '{0}' From Account Join UserState on Account.Id = UserState.Account_Id Where Account.IsFake = 1", sqlFormattedDate);
using (var session = x.Get())
{
ISQLQuery sqlquery = session.CreateSQLQuery(query);
sqlquery.ExecuteUpdate();
}
}