public ActionResult Index() { RepositoryService.CreateDefaultObject("Account"); RepositoryService.AddField("Account", "AccountName", "varchar(255)"); RepositoryService.Insert("INSERT INTO Account (AccountName) VALUES ('Test')"); var accounts = RepositoryService.Select <dynamic>("SELECT * FROM Account"); return(View(accounts)); }
public ActionResult Index() { RepositoryService.CreateDefaultObject("Account"); RepositoryService.AddField("Account", "FirstName", "varchar(255)"); RepositoryService.Insert("INSERT INTO Account (FirstName) VALUES ('Test " + DateTime.Now.ToString() + "')"); var accounts = RepositoryService.Select <dynamic>("SELECT * FROM Account"); var list = new List <Dictionary <string, string> >(); foreach (var account in accounts) { var dictionary = new Dictionary <string, string>(); foreach (KeyValuePair <string, object> kv in account) { dictionary[kv.Key] = kv.Value?.ToString(); } list.Add(dictionary); } return(View(list)); }