我正在嘗試在 .Net Standard 2.0 項(xiàng)目中使用 c# 和 microsoft.data.sqlite 實(shí)現(xiàn) SQLite 數(shù)據(jù)庫。當(dāng)我調(diào)用 connection.Open() 時(shí)，我不斷收到錯(cuò)誤“找不到方法：'IntPtr SQLitePCL.sqlite3.get_ptr()'”我已經(jīng)下載了以下 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>我執(zhí)行如下：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(); } }一切都建立起來了。在運(yùn)行時(shí)，當(dāng)執(zhí)行以下塊時(shí)，我得到：“未找到方法：'IntPtr SQLitePCL.sqlite3.get_ptr()'”on Connection.Open();
1 回答
千萬里不及你
TA貢獻(xiàn)1784條經(jīng)驗(yàn) 獲得超9個(gè)贊
將 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 關(guān)注
- 116 瀏覽
添加回答
舉報(bào)
0/150
提交
取消