我正在嘗試在 .Net Standard 2.0 項目中使用 c# 和 microsoft.data.sqlite 實現 SQLite 數據庫。當我調用 connection.Open() 時，我不斷收到錯誤“找不到方法：'IntPtr SQLitePCL.sqlite3.get_ptr()'”我已經下載了以下 Nuget 包：<ItemGroup> <PackageReference Include="Microsoft.Data.SQLite" Version="2.2.6" /> <PackageReference Include="Microsoft.Data.Sqlite.Core" Version="2.2.6" /> <PackageReference Include="SQLitePCLRaw.bundle_green" Version="2.0.0" /> <PackageReference Include="SQLitePCLRaw.core" Version="2.0.0" /> <PackageReference Include="SQLitePCLRaw.lib.e_sqlite3" Version="2.0.0" /> <PackageReference Include="SQLitePCLRaw.provider.e_sqlite3" Version="2.0.0" /> <PackageReference Include="SQLitePCLRaw.provider.e_sqlite3.netstandard11" Version="1.1.14" /> </ItemGroup>我執行如下：private static SqliteConnection _sqlConnection = new SqliteConnection(@"Data Source = myPath");public static Int64 InsertTransaction(string stringToInsert) { SQLitePCL.Batteries_V2.Init(); StringBuilder sqlToExecute = new StringBuilder(); sqlToExecute.Append("INSERT INTO table"); sqlToExecute.Append("(columnName) "); sqlToExecute.Append("VALUES(' " + stringToInsert+ "')"); using (SqliteConnection connection = _sqlConnection) { connection.Open(); SqliteTransaction transaction = connection.BeginTransaction(); SqliteCommand sqlCommand = new SqliteCommand(sqlToExecute.ToString(), connection, transaction); sqlCommand.ExecuteNonQuery(); } }一切都建立起來了。在運行時，當執行以下塊時，我得到：“未找到方法：'IntPtr SQLitePCL.sqlite3.get_ptr()'”on Connection.Open();
1 回答
千萬里不及你
TA貢獻1784條經驗 獲得超9個贊
將 Microsoft.Data.Sqlite 和 Microsoft.Data.Sqlite.Core 包更新到 Entity Framework Core 版本 3.0.0 將解決該問題。這是我的 package.config 參考：
<packages> ??<package?id="Microsoft.Data.Sqlite"?version="3.0.0-preview9.19423.6"?targetFramework="net461"?/> ??<package?id="Microsoft.Data.Sqlite.Core"?version="3.0.0-preview9.19423.6"?targetFramework="net461"?/> ??<package?id="SQLitePCLRaw.bundle_e_sqlite3"?version="2.0.2-pre20190904113843"?targetFramework="net461"?/> ??<package?id="SQLitePCLRaw.bundle_green"?version="2.0.2-pre20190904113843"?targetFramework="net461"?/> ??<package?id="SQLitePCLRaw.core"?version="2.0.2-pre20190904113843"?targetFramework="net461"?/> ??<package?id="SQLitePCLRaw.lib.e_sqlite3"?version="2.0.2-pre20190904113843"?targetFramework="net461"?/> ??<package?id="SQLitePCLRaw.provider.dynamic_cdecl"?version="2.0.2-pre20190904113843"?targetFramework="net461"?/> ??<package?id="System.Buffers"?version="4.5.0"?targetFramework="net462"?/> ??<package?id="System.Memory"?version="4.5.3"?targetFramework="net462"?/> ??<package?id="System.Numerics.Vectors"?version="4.6.0-preview5.19224.8"?targetFramework="net461"?/> ??<package?id="System.Runtime.CompilerServices.Unsafe"?version="4.6.0-preview9.19421.4"?targetFramework="net461"?/> ??</packages>
- 1 回答
- 0 關注
- 119 瀏覽
添加回答
舉報
0/150
提交
取消