/// <summary> /// Execute the current sql buffered in CurrentSql /// </summary> public void Execute() { if (CurrentSql != null) { CurrentSql.Execute(Database); } }
/// <summary> /// Execute a query using the current sql buffered in CurrentSql /// and returning the results as a representation of /// the specified tableName /// </summary> /// <param name="tableName"></param> /// <returns></returns> public IEnumerable <dynamic> Retrieve(string tableName) { if (CurrentSql != null) { DataTable table = CurrentSql.GetDataTable(Database); table = MapDataTable(tableName, table); IEnumerable <dynamic> results = table.ToDynamicList(); CurrentSql = null; return(results); } return(new List <dynamic>()); }