从.NET中与SQLite交流的最佳/最简单方法是什么？

Question says it all, really. My application is a time tracker. It's currently written as a spreadsheet, but there's just too much data and I would like to impose a bit more structure on it.

问题说明了一切,真的。我的应用程序是一个时间跟踪器。它目前是作为电子表格编写的,但是数据太多了,我想对它施加更多的结构。

SQLite seems like a neat way to go.
I would be open to other suggestions, too.

SQLite似乎是一个很好的方式。我也愿意接受其他建议。

3 个解决方案

#1

There are some providers available:

有一些提供商可用:

http://sqlite.phxsoftware.com/

http://sourceforge.net/projects/sqlite-dotnet2

And you can get up and running in just three minutes according to this chap:

根据这篇文章,你可以在三分钟内启动并运行:

http://www.mikeduncan.com/sqlite-on-dotnet-in-3-mins/

Updated Jan 5 2009: We actually have this rolled out to our shared (partial trust) hosting environment and it works really well according to early customer feedback.

2009年1月5日更新:我们实际上已将其推广到我们的共享(部分信任)托管环境,并且根据早期客户反馈,它可以很好地工作。

#2

The current (april 2011) links seem to be here System.Data.SQLite 1.0.70.0 (3.7.6)

当前(2011年4月)链接似乎在这里System.Data.SQLite 1.0.70.0(3.7.6)

But there seems to be some problem with the installer. The doen't install SQLite.Interop.dll properly to GAC.

但是安装程序似乎存在一些问题。不要将SQLite.Interop.dll正确安装到GAC。

I did not install it in GAC and load it with absolut path and that works fine for me.

我没有在GAC中安装它并用绝对路径加载它,这对我来说很好。

Just noted, that the ticket is open again. Check there for new work arounds and solutions.

刚才注意到,机票再次开放。检查那里的新工作和解决方案。

#3

If you are working on an open source application and want a lightweight interop layer to SQLite, then the SQLite code in Media Portal may be of interest (see SQLiteClient.cs)

如果您正在开发一个开源应用程序并想要一个轻量级的互操作层到SQLite,那么Media Portal中的SQLite代码可能会很有用(参见SQLiteClient.cs)

#1