public ActionResult Details(int id) { using (var connection = ConnectionConfiguration.GetOpenConnection(LoggaConfiguration._connectionString)) { var logga = connection.Query <LoggaEntry>("SELECT * FROM LoggaEntry WHERE LoggaEntryId = @id", new { id = id }).FirstOrDefault(); return(View(logga)); } }
public ActionResult Index() { using (var connection = ConnectionConfiguration.GetOpenConnection(LoggaConfiguration._connectionString)) { var loggaList = connection.Query <LoggaEntry>("SELECT * FROM LoggaEntry"); return(View(loggaList)); } }