我已对此进行了测试,而且我可以看到,从多个申请(或相同申请)到同一访问数据库,甚至还有许多<代码>OleDbataReader同时开放。
但这是否安全? 如果我得到任何特别照顾或将采用<代码> 喷射灯/密码发动机对一切照相? 如果我阅读一个数据表,同时向同一表格书写,将会发生什么情况?
I just don t want to stumble upon gotchas or surprises later on.
获取一般不是同时进行数据活动的发动机。 您为什么会避免MySQL或Oracle或其他适当的RDBMS?
某些原因:
-You are not guaranteed a read consistent view.
-You get the strong possibility of updating an updated record without knowing.
-You may experience unresolvable locks
-You have no centralized transaction manager
准入不是同时使用。 http://databases.aspfaq.com/database/what-are-the-limitations-of-ms-access.html 此处为关于这一主题的出色文章。
To directly response to your question What would happen if I m reading one data table while writing to the same table at the same time?
取决于缺损<代码>。 你们可以读到底层是什么,以及如何在http://msdn.microsoft.com/en-us/library/ms971557.aspx” rel=“nofollow”上加以具体说明。 保护您的数据完整性与ADO.Net中的交易。
但正如其他人建议的那样,请使用其他东西:SQL 2008 Express <,但完全是免费的。 如果你仍然希望能够使用数据库而不安装服务器软件,我甚至建议
我的个人经验是,对于5至10个用户(每个用户有1个链接)来说,“用户可以通过将一些投入打入一个表格而输入的数据”在当地网络中使用,“上网”是一种支持。 本条反映了我的个人经历:
The real limits and the point where you should look for a "real" Client/Server database is heavily dependent of the details of your environment - if you want to know, you will have to run your own benchmarks.
Concerning the concurrent read/writes to a table: Access uses the byte-range locking capabilities of the underlying file system to deal with collisions (see here http://en.wikipedia.org/wiki/File_locking for more information). This mechanism works on most modern file systems like NTFS, but does not scale well to many users.
What is the use of default keyword in C#? Is it introduced in C# 3.0 ?
I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...
I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...
I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...
I have two EF entities. One has a property called HouseNumber. The other has two properties, one called StartHouseNumber and one called EndHouseNumber. I want to create a many to many association ...
How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...
Since I cannot order my dictionary, what is the best way of going about taking key value pairs and also maintaing an index?
Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...
