Database with .NET

[Madz]

I use MSSQL Server ,and still not touched orcle. with cross platform development i like MYSQL the best.

[Guest mutant]

I use MSAccess and MSSQL now, been playing with Acces more lately. Never tried MySQL with .NET.

[wyrd]

I'm using MSDE 2000 to get some practice with how MS SQL Server 2000 works. You should of listed Access as well that's quite popular (I imagine most if not all of the "other" are using Access)

[Robby]

I use mostly SQL Server 2000, and still support Access.

[sizer]

I'm using MySQL . It's free and i don't need to sell it with my Applications which is good, "bad" thing is that MySQL don't support triggers and stored procedures YET.Also i'm using Access , and from my point of view it have more disadvantages than advantages , so I'm using Access for temporary DB!

[hog]

I'm using Access but like the idea of moving to MSDE eventually

[steved]

Here at work I'm using MSSQL and MSDE for enterprise and desktop apps I develop (respectively). I'll dip into Access if someone wrote a crappy VBA/VB6 app with it, but I like to avoid it if possible.

 

Cross-platform I'm using Oracle for business/enterprise systems and MySQL for mucking around with and any system that can't afford Oracle (money-wise or resource-wise :) ). I think MySQL is beautiful. Once it becomes full-featured, hopefully it will become as ubiquitous as the overprised DB solutions we have right now.

 

PS: I guess, technically, I haven't done any dev work w/ MySQL and .NET together. But considering how light and poweful it has been in the past for my PHP and client/server apps, I figured it deserved a vote. ;)

[iebidan]

SQL Server 2000 and Access 2002

[rufus]

SQL Server and MS Access.

[Ariez]

I wish MSDE was more portable.

You have to be a business to be willing to have a SQL server running even if its free...

As a private user, I wouldn't like the idea of a 200 mg download as a prerequisite to this 300k program setup.

I wish Access had stored procedures...

[Robby]

you can work with SP in Access, you just cannot view them.

 

Take a look ...http://www.devcity.net/net/article.aspx?alias=msaccess_sp2

[Derek Stone]

As a private user, I wouldn't like the idea of a 200 mg download as a prerequisite to this 300k program setup.

As a private user, I wouldn't like the idea of a program using Access. MSDE is a 68.4 MB download, something I, as a dial-up user, would gladly suck up for a decent program.

[Ariez]

Robby, you just opened me a new perspective.

Stored procedures in access....!

I going to have a look at that article...

[jssk]

I'm using "other", which is Matisse object database http://www.matisse.com

Native ADO.NET provider provided. No O/R mapping needed. SQL is faster than SQL Server. The database is easily accessible from Java, C++, PHP, Perl. Windows/Linux.

 

I like it better than SQL Server or MySQL.

[kleptos]

I use MSSQL at work so i tend to stick with the same outside of work. I have written a few MySQL databases as well, but i prefer to use alot of stored procedures and functions in my database coding, i havent ventured outside MSSQL, cept for MySQL.

[Roey]

What's MSDE (guessing Developer Edition of SQL)

[kleptos]

Microsoft SQL Desktop Edition.

 

Its not even a developer edition, its more of a portable database you can distribute. Its a very scalled down version of SQL. Its cool, its free, just no tools come with it.

[tinomesa]

I'd like to use SQL 2000 more, but I can justify it to mgmt just yet.

[kleptos]

I'd like to use SQL 2000 more, but I can justify it to mgmt just yet.

 

What are you using now?

[Diablicolic]

I'm using MSSQL

[KenpoMatt]

We're Oracle all the way, here. We have migrated away from ODBC's. Who knows, maybe we'll get some SQLServer going on soon.

[kleptos]

I tried to understand Oracle, but coming from MSSQL and Enterprise Manager, i couldnt grasp the technique to run and use Oracle. So i stayed with MSSQL. I anxiously await Microsofts newest version of MSSQL.

[SysRq2000]

I started using Access but after a while it got to slow, so now im only using MS-SQL... Don't you just love stored procedures? ;)

 

- SysRq

[kleptos]

I use stored procedures all the time. They are great, between stored procedures and functions, i can do almost anything in MSSQL.

[techmanbd]

I use MS ACCESS. I have used SQL Server 7 and Oracle 8.1, but the company i work for now only has ACCESS. They are not big on data here, but i plan on trying to change that. hehe