如何使用 C# 以编程方式定位我的 Google Drive 文件夹? [英] How do I programmatically locate my Google Drive folder using C#?

问题描述

与这里.仅用于 Google Drive 而不是 Dropbox:

Similar question as here. Just for Google Drive instead of Dropbox:

如何使用 C# 以编程方式定位我的 Google Drive 文件夹?

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

• 注册表?
• 环境变量?
• 等等……

推荐答案

我个人认为，最好的办法是通过SQLite3访问同一个文件.

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();

您可以从 获取 .Net 的 SQLite 库这里.还要添加对 System.Data.SQLite 的引用并将其包含在您的项目中以运行上述代码.

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.

要检索用户，请从上述代码中替换 entry_key='user_email'

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

这篇关于如何使用 C# 以编程方式定位我的 Google Drive 文件夹?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！