blocks|key|3057130|text|有一个完全托管的SQLite+translation。如果你使用它，那么你可以在Mono和Windows上使用相同的DLL。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3057131|另一种解决问题的方法是创建自己的数据库接口，然后在单独的DLL中为Mono实现一次，为微软.NET实现一次。(基本上与创建在不同数据库上运行的代码的方式相同)|3057132|entityMap|0|LINK|mutability|MUTABLE|url|http://code.google.com/p/managed-sqlite/^0|8|I|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

There is a fully managed <a href="http://code.google.com/p/managed-sqlite/" rel="nofollow noreferrer">SQLite translation</a>. If you use that, then you could use the same DLL on Mono and Windows.

Another way to solve your issue is to create your own database-interface and then implement that interface once for Mono and one for Microsoft .NET in separate DLLs. (Basically the same way you create code that runs against different databases)

blocks|key|313980|text|您可以使用别名来解决命名差异|type|unstyled|depth|inlineStyleRanges|entityRanges|data|313981|#if+(linux)
++using+SqlCommand+=+Mono.Data.Sqlite.SqliteCommand;
#else
++using+SqlCommand+=+System.Data.SQLite;|code-block|syntax|javascript|313982|我认为为不同的构建使用不同的程序集是一项更复杂的任务。您可以查看MSBuild文档|313983|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can solve the naming differences using alias

<pre><code>#if (linux)
 using SqlCommand = Mono.Data.Sqlite.SqliteCommand;
#else
 using SqlCommand = System.Data.SQLite;
</code></pre>

Using different assemblies for different builds is a more complex task i think.. you can have a look at the MSBuild documentation

blocks|key|3057259|text|开源的WindowsORM库使用平台的Vici+CoolStorage驱动程序在Windows+(.NET)、Mono+(Mac、Linux和Windows)和MonoTouch+(iPhone)上运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3057260|要在这些不同的平台上使用它，您不需要对源代码进行任何更改。只需重新编译，它应该可以工作。|3057261|entityMap|0|LINK|mutability|MUTABLE|url|http://viciproject.com/coolstorage^0|J|G|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

The open-source <a href="http://viciproject.com/coolstorage" rel="nofollow noreferrer">Vici CoolStorage</a> ORM library works on Windows (.NET), Mono (Mac,Linux and Windows) and MonoTouch (iPhone) using that platform's SQLite driver.

To use it on these different platforms, you don't have to change anything to your source code. Just recompile, and it should work.

blocks|key|3057281|text|我建议您首先尝试找到一种在Windows和Linux中都能工作的实现。如果这不起作用，那么创建一个为SQLite定义公共接口的程序集，并将所有"#if+LINUX“代码放入该程序集中。然后在主应用程序中使用该程序集，以避免将所有#定义弄乱主应用程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3057282|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

IMO you should first try to find an implementation that works in both Windows and Linux. If that doesn't work, create an assembly that defines a common interface for SQLite and put all you "#if LINUX" code in that assembly. Then use that assembly in the main application to avoid cluttering the main app with all the # defines.

blocks|key|3057318|text|SQLite+ADO.NET提供程序实际上是一个包含本机SQLite库的混合模式程序集。当然，这个本地库在Windows和Linux上是不同的，所以这个提供程序不能在Linux上工作。但是，提供程序只有一个托管版本(下载页面上的SQLite-1.0.65.0-managedonly-binaries.zip)。所以我认为你只需要使用这个版本的提供者，并提供足够的原生SQLite动态库(+Windows上的.dll，Linux上的.so+)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3057319|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The SQLite ADO.NET provider is actually a mixed-mode assembly, which contains the native SQLite library. This native library is not the same on Windows and Linux of course, so this provider doesn't work on Linux. However, there is a managed-only version of the provider (SQLite-1.0.65.0-managedonly-binaries.zip on the download page). So I think you just need to use this version of the provider, and provide the adequate native SQLite dynamic library along with it (.dll on Windows, .so on Linux)

blocks|key|3057380|text|你可以只在你的软件的Windows和Linux版本上使用SQLite的单声道实现。只需在您的软件包中包含SQLite的mono程序集并在本地引用它即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3057381|正如你在上一篇文章中读到的here，你可以在你的代码中单独使用mono的托管方式，只需要以不同的方式重新分发windows的本机部分即可。但您不必纠结于托管实现、冗余和编码。|offset|length|3057382|entityMap|0|LINK|mutability|MUTABLE|url|http://go-mono.com/forums/#nabble-td1505622^0|0|D|4|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

You can just use the mono implementation of SQLite for both, Windows and Linux versions of your software. Just include the mono assembly for SQLite in your software package and refer to it locally.

As you can read <a href="http://go-mono.com/forums/#nabble-td1505622" rel="nofollow noreferrer">here</a> in the last post, you can use the managed way of mono solely in your code and need just to redistribute the native part for windows differently. But you do not have to mess with to managed implementations and redundand code through that.

blocks|key|315112|text|您可以使用csharp-sqlite，它是到Sql-Lite的C#的一个端口。它非常活跃，并且基于3.6.22版本的SqlLite。请参阅Miguel的comments，了解如何尝试加快速度。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|315113|entityMap|0|LINK|mutability|MUTABLE|url|http://code.google.com/p/csharp-sqlite/|1|http://tirania.org/blog/archive/2009/Aug-06.html^0|5|D|0|24|8|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

You can use <a href="http://code.google.com/p/csharp-sqlite/" rel="nofollow noreferrer">csharp-sqlite</a> which is a port to C# of Sql-Lite. It is very active and based on 3.6.22 version of SqlLite. See Miguel's <a href="http://tirania.org/blog/archive/2009/Aug-06.html" rel="nofollow noreferrer">comments</a> on attempts to try to speed it up.

blocks|key|3057457|text|一些答案建议使用完全托管的C#+port+of+SQLite3。但是，不幸的是，尽管可以用Mono+C#编译器编译，但到目前为止还没有发布支持Linux或Mac。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3057458|未来的版本将正确地运行在那些使用Mono运行时的非Windows平台上。WIth一些注意事项，source+repository包含了可以正常工作的代码。|3057459|话虽如此，可从sqlite.org获得的System.Data.SQLite实现在视窗和非视窗平台上同时适用于.Net和Mono。您只需要确保Mono在运行时使用的app.config将(C%2B%2B)+SQLite3+dll映射到适当的.so或.dylib库。如果你选择“混合模式”版本，那么它应该可以正常工作，你不需要担心单独的dll。|3057460|entityMap|0|LINK|mutability|MUTABLE|url|http://code.google.com/p/csharp-sqlite/|1|http://code.google.com/r/stewartadcock-csharp-sqlite-updates/source|2|http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki^0|D|I|0|0|1B|H|1|0|K|I|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|H|3|-4|5|6|7|15|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]|R|$5|K|L|M|C|$N|S]]]]

Some answers suggest the fully-managed <a href="http://code.google.com/p/csharp-sqlite/" rel="nofollow">C# port of SQLite3</a>. But, unfortunately, no release to date supports Linux or Mac OS X despite being compilable with the Mono C# compiler.

A future release will correctly run on those non-Windows platforms with the Mono runtime. WIth some caveats, the <a href="http://code.google.com/r/stewartadcock-csharp-sqlite-updates/source" rel="nofollow">source repository</a> contains code that works.

Having said that, the <a href="http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki" rel="nofollow">System.Data.SQLite</a> implementation available from sqlite.org works with both .Net and Mono, on Windows and non-Windows platforms. You just need to ensure that the app.config used by Mono at runtime maps the (C++) SQLite3 dll to the appropriate .so or .dylib library. If you choose the "mixed-mode" version, then it should just work and you don't need to worry about separate dlls.

blocks|key|3270886|text|我最近也遇到了这个问题:通过Visual+Studio在Windows上构建一个使用Sqlite的应用程序，并将其部署到Ubuntu+Server+box上进行生产。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3270887|我找到的最简单的解决方案是使用Sqlite的Mono驱动程序：。|3270888|事情本来可以简单一点，但是还没有打包到官方的Mono版本中。|3270889|所以你必须从源代码(the+general+instructions+are+here)编译Mono：|offset|length|3270890|3270891|首先编译整个Mono库，如果您想保留当前的Mono安装程序并复制Mono.Data.Sqlite.dll+|unordered-list-item|style|BOLD|3270892|3270893|3270894|，则无需安装该库|3270895|当然你可以“交叉编译”：我已经在Ubuntu+Server上构建了Mono，并在Windows+.Net项目中使用了动态链接库。|3270896|然后确保您的库路径中有+(+Windows的sqlite3.dll和Linux的sqlite3.so+)：对于Windows，我只需将SQLite3.dll复制到Mono.Data.Sqlite.dll程序集旁边，对于Linux，它应该可以开箱即用。|3270897|然后，您的项目应该在Windows/.Net和Linux/Mono环境中无缝工作。|3270898|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/mono/mono^0|0|0|0|A|X|0|0|0|W|K|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|18|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|19|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1A|8|@]|9|@$H|1B|I|1C|1|1D]]|A|$]]|$1|J|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|1F|8|@$H|1G|I|1H|N|O]]|9|@]|A|$]]|$1|P|3|-4|5|M|7|1I|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|M|7|1J|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1K|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1L|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1M|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1N|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]]|10|$11|$5|12|13|14|A|$15|16]]]]

I've recently come across the issue too: building an application that uses Sqlite on Windows with Visual Studio and deploying it on an Ubuntu Server box for production.

The simplest solution I've found is using the Mono driver for Sqlite: <a href="http://www.mono-project.com/SQLite" rel="nofollow">Mono.Data.Sqlite</a>.

Things could have been a little simpler but there is <a href="https://bugzilla.xamarin.com/show_bug.cgi?id=2148" rel="nofollow">a bug with .Net 4.0</a> that is not yet packaged in the official Mono releases.

So you'll have to compile Mono from source (<a href="https://github.com/mono/mono" rel="nofollow">the general instructions are here</a>):

<ul>
<li>first compile the whole Mono stuff</li>
<li>you do not need to install it if you want to keep your current Mono setup</li>
<li>copy the Mono.Data.Sqlite.dll library</li>
</ul>

Of course you can "cross-compile": I've built Mono on Ubuntu Server and used the dll in a Windows .Net project.

Then ensure you have <a href="http://www.sqlite.org/download.html" rel="nofollow">the native Sqlite library</a> (sqlite3.dll for Windows and sqlite3.so for Linux) in your library path: for Windows I simply copied the sqlite3.dll next to the Mono.Data.Sqlite.dll assembly, for Linux it should work out of the box.

You project should then work seamlessly in both Windows/.Net and Linux/Mono environments.

Can someone help/guide me with using SQLite lib on Linux (MONO) and Windows (.NET)

On linux i use native mono sqlite client, and on windows i use <a href="http://sqlite.phxsoftware.com/" rel="noreferrer">http://sqlite.phxsoftware.com/</a>

is there a way to define 'using' directives like this :

<pre><code>#if (linux)
 using Mono.Data.Sqlite;
#else
 using System.Data.SQLite;
</code></pre>

Another problem is small differencies on both implementations, like :

<pre><code>cmd = new SqliteCommand(); // mono
cmd = new SQLiteCommand(); // sqlite.phxsoftware.com
</code></pre>

Waiting for any help

If you know better or simplier way to do this it'll very thankfull for info.

Thanks

SQLite on C# Cross-Platform Applications

有人能帮助/指导我在Linux (MONO)和Windows (.NET)上使用SQLite lib吗？在linux上我使用本机mono sqlite客户端，在windows上我使用。有没有办法像这样定义“using”指令：#if (linux)  using Mono.Data.Sqlite;#else  using...

问C#跨平台应用程序上的SQLite
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C#跨平台应用程序上的SQLiteEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C#跨平台应用程序上的SQLite
EN