Multiuser Embedded Database Recommendations?

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I've finally decided to port a Win32 application written in Delphi to C#.
The program used an embedded database (DBISAM) that handled multiple users
well through file locking, and I'm looking for something similiar for
ADO.NET. I would really prefer not to go client-server. Can anyone make a
recommendation?

--Bruce
 
SQL Ce is not a "multiuser" database in the same sense as others mentioned.
While it can share its data, this is done via replication, not managing
multiple user access.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
Miha Markic said:
SQL Server CE should do just fine.
http://www.microsoft.com/sql/editions/compact/ssceoverview.mspx
Or Firebird.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Bruce said:
I've finally decided to port a Win32 application written in Delphi to C#.
The program used an embedded database (DBISAM) that handled multiple
users well through file locking, and I'm looking for something similiar
for ADO.NET. I would really prefer not to go client-server. Can anyone
make a recommendation?

--Bruce
Click to expand...
Click to expand...
 
Whops, you are right, I missed the multiuser requirement.
I guess one might use standard thread synchronization to get around this
problem.
 
What about SQL Server 'Express'? Is that multiuser?

William Vaughn said:
SQL Ce is not a "multiuser" database in the same sense as others
mentioned. While it can share its data, this is done via replication, not
managing multiple user access.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
Miha Markic said:
SQL Server CE should do just fine.
http://www.microsoft.com/sql/editions/compact/ssceoverview.mspx
Or Firebird.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Bruce said:
I've finally decided to port a Win32 application written in Delphi to
C#. The program used an embedded database (DBISAM) that handled multiple
users well through file locking, and I'm looking for something similiar
for ADO.NET. I would really prefer not to go client-server. Can anyone
make a recommendation?

--Bruce
Click to expand...
Click to expand...
Click to expand...
 
Yes, SQL Sever Express edition is a true multiuser database. Can it be
included with an application? Well, sort of. It has to be installed by an
Admin as it runs as a service, but yes, this can be used locally or shared
(which I prefer). In any multiuser configuration I think it's best to use a
service-type DBMS as opposed to an old-fashioned file-share database as they
are more reliable, more stable and far more scalable.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
Miha Markic said:
It is but is not embedded.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Bruce said:
What about SQL Server 'Express'? Is that multiuser?
Click to expand...
Click to expand...
 
Back
Top