How do I programmatically locate my Google Drive folder using C#?

by

I personally think, the best way is to access the same file through SQLite3.

string dbFilePath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "Google\\Drive\\sync_config.db");
if (!File.Exists(dbFilePath))
    dbFilePath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "Google\\Drive\\user_default\\sync_config.db");

string csGdrive = @"Data Source="+ dbFilePath + ";Version=3;New=False;Compress=True;";                
SQLiteConnection con = new SQLiteConnection(csGdrive);
con.Open();
SQLiteCommand sqLitecmd = new SQLiteCommand(con);

//To retrieve the folder use the following command text
sqLitecmd.CommandText = "select * from data where entry_key='local_sync_root_path'";

SQLiteDataReader reader = sqLitecmd.ExecuteReader();
reader.Read();
//String retrieved is in the format "\\?\<path>" that's why I have used Substring function to extract the path alone.
Console.WriteLine("Google Drive Folder: " + reader["data_value"].ToString().Substring(4));
con.Dispose();

You can get the SQLite library for .Net from here.
Also add reference to System.Data.SQLite and include it in your project to run the above code.

To retrieve the user, relpace entry_key='user_email' from the above code

More Related Contents:

  1. Why use the ‘ref’ keyword when passing an object?
  2. Double to string conversion without scientific notation
  3. How costly is .NET reflection?
  4. Best way to compare two complex objects
  5. What are attributes in .NET?
  6. A generic list of anonymous class
  7. How to read a large (1 GB) txt file in .NET?
  8. Requested registry access is not allowed
  9. Duplicate keys in .NET dictionaries?
  10. .NET Memory issues loading ~40 images, memory not reclaimed, potentially due to LOH fragmentation
  11. Getting / setting file owner in C#
  12. Printing to a client printer from a web app
  13. How do I group Windows Form radio buttons?
  14. .NET : How do you get the Type of a null object?
  15. Embedding DLLs in a compiled executable
  16. Why does the async keyword exist
  17. How can I deploy a .NET application that uses ODAC without installing the whole component to the user?
  18. Difference between IEnumerable Count() and Length
  19. “new” keyword in property declaration in c#
  20. How to parse and generate DateTime objects in ISO 8601 format
  21. How to navigate a few folders up?
  22. Why does Environment.Exit() not terminate the program any more?
  23. How do you log the machine name via log4net?
  24. How do I pass credentials to a machine so I can use Microsoft.Win32.RegistryKey.OpenRemoteBaseKey() on it?
  25. C# FileSystemWatcher, How to know file copied completely into the watch folder
  26. What’s the best way to ensure a base class’s static constructor is called?
  27. Why does the default string comparer fail to maintain transitive consistency?
  28. (0 == variable) or (null == obj): An outdated practice in C#? [duplicate]
  29. C# generic methods, type parameters in new() constructor constraint
  30. Adjust brightness, contrast and gamma of an image

Leave a Comment