|
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.
|
|
|
|
|
Only used Oracle in database course projects, not really since then and that was 4 years ago...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I don;t know .
why i don't like use database ,i Just Use XML.
chinese!
|
|
|
|
|
It seems that embedded databases are getting its due
What about being open source like Berkeley DB?
"Silence will create respect and dignity; justice and fair play will bring more friends;
benevolence and charity will enhance prestige and position; courtesy will draw benevolence;
service of mankind will secure leadership and good words will overcome powerful enemies"
Ali (Peace be upon him)
|
|
|
|
|
db4o is very good and easy with C#.
|
|
|
|
|
My data stores are nowhere complex enough to warrant a full-on SQL database. I use XML and do my searches with XPath. XPath is really, really handy once you grok the syntax.
|
|
|
|