protected void Page_Load(object sender, EventArgs e) { using (TodoListContext context = new TodoListContext()) { ITaskRepository taskRepo = new EFTaskRepository(context); ISystemInfoRepository sysRepo = new EFSystemInfoRepository(); LoadLandingPageData useCase = new LoadLandingPageData(taskRepo, sysRepo); User theuser = new User { UserId = 1 }; LandingPageData data = useCase.GetData(theuser); ActiveUser = data.ActiveUsers; TotalTask = data.TotalTasks; //var connectionFromConfiguration = WebConfigurationManager.ConnectionStrings["ToDoListStr"]; //using (SqlConnection dbConnection = new SqlConnection(connectionFromConfiguration.ConnectionString)) //{ // try // { // dbConnection.Open(); // Message = "Connection Succesfull"; // } // catch (SqlException ex) // { // Message = "connection failed"; // } //} } }
public void Data(string connectionString) { _taskRepository = new EFTaskRepository(new TaskManagerContext(connectionString)); }