public List <string> Preview(string key, string url) { List <string> results = new List <string>(); string rkLowerFilter = TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.Equal, LinkRow.CreateMD5(url)); string pkUpperFilter = TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, key); // Note CombineFilters has the effect of “([Expression1]) Operator (Expression2]), as such passing in a complex expression will result in a logical grouping. string combinedFilter = TableQuery.CombineFilters(rkLowerFilter, TableOperators.And, pkUpperFilter); try { TableQuery <LinkRow> rangeQuery = new TableQuery <LinkRow>() .Where(combinedFilter); var result = DBConnect.GetLinkTable().ExecuteQuery(rangeQuery).Take(1).ToList(); LinkRow res = result[0]; results.Add(res.Title); results.Add(res.URL); results.Add(res.Img); results.Add(res.Body); } catch { results.Add("No Preview Found"); } return(results); }
public List <string> GetTitle(string q) { List <string> titledate = new List <string>(); try { TableQuery <LinkRow> rangeQuery = new TableQuery <LinkRow>() .Where( TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.Equal, LinkRow.CreateMD5(q)) ); var results = DBConnect.GetLinkTable().ExecuteQuery(rangeQuery); foreach (var row in results.Take(1)) { titledate.Add(row.Title); titledate.Add("Published: " + row.DatePublished.ToString()); } return(titledate); } catch { titledate.Add("No Page Found"); titledate.Add("Try a different URL"); return(titledate); } }