public static T Load <T>(this DirectQueryLoader <T> loader, long id) where T : DirectModel { var dc = loader.Database.LoadContainer(loader.ContructLoadByID(id)); if (!dc.HasValue) { return(null); } T result = loader.Cast(dc); return(result); }
public static async Task <T> LoadSingleAsync <T>(this DirectQueryLoader <T> loader) where T : DirectModel { string command = string.Format("SELECT {0} FROM [].{1} {2} LIMIT 1", loader.SelectQuery, loader.Instance.TableName, loader.WhereQuery); var dc = await loader.Database.LoadContainerAsync(command); if (!dc.HasValue) { return(null); } return(loader.Cast(dc)); }
public static async Task <T> LoadAsync <T>(this DirectQueryLoader <T> loader, int id) where T : DirectModel { string command = string.Format("SELECT {0} FROM [].{1} WHERE {2}={3};", loader.SelectQuery, loader.Instance.GetTableName(), loader.Instance.GetIdNameValue(), id); var dc = await loader.Database.LoadContainerAsync(command); if (!dc.HasValue) { return(null); } return(loader.Cast(dc)); }
public static async Task <T> LoadAsync <T>(this DirectQueryLoader <T> loader, string query) where T : DirectModel => loader.Cast(await loader.Database.LoadContainerAsync(query));
public static T Load <T>(this DirectQueryLoader <T> loader, string query) where T : DirectModel => loader.Cast(loader.Database.LoadContainer(query));