|
sybase has different database for every application type I need
|
|
|
|
|
|
VistaDB is very well suited to small projects that need a lightweight database you can XCopy around. It scales better than Access and is all managed code.
http://www.vistadb.net
Jason S Short, Ph.D.
VistaDB Software, Inc.
|
|
|
|
|
Same here. Mostly SQL 2005 Express, MySQl, or even FirebirdSQL...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Nice, small and fast library. I'd say it is much easier to use for embedded DB comparing to other listed DBs above.
/ototo
|
|
|
|
|
I use the new VISTADB 3 instead of Access.
I'm satisfied with this product, a db totally interact with Visual Studio
VictorK
|
|
|
|
|
I use VistaDB quite often... It's embedded, lightweight, 100% .NET, and has some pretty cool tools to migrate data from Access or SQL Server.
|
|
|
|
|
what is vistadb? never heard of it before
Gia Nhut
|
|
|
|
|
Their web site is http://www.vistadb.net
It's T-SQL compatible with SQL Server 2005, supports transactions, .NET stored procedures, runs in .NET 1.1, .NET 2.0, the .NET compact framework, and Mono.
I like it because I can xcopy deploy it with my web applications and not have to deal with the web hosting company to set anything up.
Oh, and it's about 700k in size.
|
|
|
|
|
does it have any restriction like Database size? table size? how about speed?
Gia Nhut
|
|
|
|
|
Speed is like what you would expect from an Access or other file based system. Since it is also 100% managed code it is not as fast as some others. But it is VERY lightwieght, runs under Compact Framework, Mono (Linux and Mac OS), and you can even buy the source code.
Jason S Short, Ph.D.
VistaDB Software, Inc.
|
|
|
|
|
What kind of projects that require people use oracle? it is sure a great database though, but
1. heavy
2. expensive
3. hard to use (!!?!)
Gia Nhut
|
|
|
|
|
gianhut wrote: What kind of projects that require people use oracle? it is sure a great database though, but
1. heavy
2. expensive
3. hard to use (!!?!)
Wrong Brother, Oracle is infact a very very good database, and cross-platform for your information, but it is mostly geared toward Java not .NET.
AlbertDadze
|
|
|
|
|
The user interface is the worst I've ever seen though...
[EDIT] In fact, it's completely user unfriendly[/EDIT]
|
|
|
|
|
Yeah SQLplus is the only tool the provide, has somebody at Oracle heard of the word GUI.
.net is a box of never ending treasures, every day I get find another gem.
|
|
|
|
|
There's SQL developer for Oracle. I've used it several times. However I stick to gv editor mainly.
And out company uses oracle extensivly. For both unix and windows environment.
Tom Wright
tawright915@gmail.com
|
|
|
|
|
Best GUI for Oracle: Toad 9.0
|
|
|
|
|
Shames it's third party and you have to pay for it, come on - a tool like that should be bundled with Oracle.
.net is a box of never ending treasures, every day I get find another gem.
|
|
|
|
|
Yes, you have your point.
|
|
|
|
|
Toad for Oracle makes working in Oracle damn easy, specially the PL/SQL and DBA part. There is a free, stripped down version available for use. But the full version is expensive, but feature-rich.
reach2dpg
|
|
|
|
|
Albert Dadze wrote: very very good database
Maybe, once you've stuggled to install it and come to grips with SQLPlus and paid a DBA to maintain it, sure it's great if you like hard to use products.
.net is a box of never ending treasures, every day I get find another gem.
|
|
|
|
|
I saw a presentation at TechEd 2007 last week from Oracle that they plan to support LINQ for Dot Net, and they have a new provider coming. So I think Oracle is getting more serious about Dot Net.
Jason S Short, Ph.D.
VistaDB Software, Inc.
|
|
|
|
|
I'm giving you a 5, I can tell you've come into contact with Oracle before.
.net is a box of never ending treasures, every day I get find another gem.
|
|
|
|
|
But, why do you think most financial companies use Oracle?!
|
|
|
|
|
EntitySpaces makes using Oracle trivial, no kidding, see http://www.entityspaces.net, in fact, our unit tests run the same binary against VistaDB, Microsoft SQL, Oracle, MySQL and Access, true db independence, and very intuitive API.
Employee emp = new Employee();
emp.FirstName = "Mike";
emp.LastName = "Smith";
emp.Save();
Dynamic Query
EmployeeCollection coll = new EmployeeCollection();
emp.Query.Where(coll.Query.LastName.Like("Smi%"));
if (coll.Query.Load())
{
foreach (Employee emp in coll)
{
Console.WriteLine(emp.FirstName);
}
}
We support Oracle Sequences and Hierarchical Models, all kinds of cool stuff.
|
|
|
|