public static Project LoadProject(string existingProject) { try { string projectsPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location); Project loadedProj = new Project(); string projectSQL = "SELECT project_base64 FROM project"; // WHERE id_project=0"+id_samples.ToString(); SQLiteConnection projectConn = new SQLiteConnection("Data Source=" + projectsPath + @"\\Projects\\" + existingProject + ".db;Version=3;New=False;Compress=True;Synchronous=Off"); SQLiteCommand cmd = new SQLiteCommand(projectSQL, projectConn); projectConn.Open(); loadedProj = (Project)ConversionUtilities.DeserializeBase64((string)cmd.ExecuteScalar()); // using(SQLiteDataReader sqReader = cmd.ExecuteReader()) // { // if (sqReader.Read()) // { // loadedProj = (Project)ConversionUtilities.DeserializeBase64(sqReader.GetString(0)); // } // } projectConn.Close(); return(loadedProj); } catch (Exception ex) { throw ex; } }