how do you mean "what database do you usually use"
Everyone has their own way/product they use. It also depends on the type of application.
Please tell us the type of application you are creating.
Some people use Xml to store data locally, which is ideal for a mini mini database
some people use MS Access locally to store data instead of using SQL Server - this would be a better approach if you are not doing major database stuff
some people use SQL Server because not only is it industry standard but because it is good at managing and processing large amounts of data, which has more potential than MS Access, since MS Access was designed for a "small" environment, if that makes sense
again, it depends on your application
There is no MSDE 2005 - there is SQL Server Express 2005, a free (but limited) version of SQL Server
I test on MSSQL 2005, but run my company's 2 major apps on MSSQL 2000. If you're just making a small windows application, I think you can use the free MSDE 2005 for it.
If you are doing lots of simple stuff and mainly data storage then XML might be the way for you.
If you want to live on the edge and need more advanced data manipulation such as sorting and inserting then you might want to take a look at LINQ. Linq offers a fine line between simple XML and advanced databases without going into a full blown database which can be a nightmare to begin off with, especially when it comes to deploying it or giving it to your firneds or a few small businesses. I think LINQ really simplifies that if you dont need ALL of the functionality of a database.
If you do need the fully blown power of a database then i strongly recommend MS SQL 2005. There are many versions some of which are free.
You should probably let us know what your application is going to do and who your intended target is (who will be using it). Then we will be able to provide more accurate advice.
What database are you using?
xRuntime
how do you mean "what database do you usually use"
Everyone has their own way/product they use. It also depends on the type of application.
Please tell us the type of application you are creating.
Some people use Xml to store data locally, which is ideal for a mini mini database
some people use MS Access locally to store data instead of using SQL Server - this would be a better approach if you are not doing major database stuff
some people use SQL Server because not only is it industry standard but because it is good at managing and processing large amounts of data, which has more potential than MS Access, since MS Access was designed for a "small" environment, if that makes sense
again, it depends on your application
There is no MSDE 2005 - there is SQL Server Express 2005, a free (but limited) version of SQL Server
Lorry Craig
Wyatt Earp
GL,
Jasmine
JamesPMiller
If you are doing lots of simple stuff and mainly data storage then XML might be the way for you.
If you want to live on the edge and need more advanced data manipulation such as sorting and inserting then you might want to take a look at LINQ. Linq offers a fine line between simple XML and advanced databases without going into a full blown database which can be a nightmare to begin off with, especially when it comes to deploying it or giving it to your firneds or a few small businesses. I think LINQ really simplifies that if you dont need ALL of the functionality of a database.
If you do need the fully blown power of a database then i strongly recommend MS SQL 2005. There are many versions some of which are free.
You should probably let us know what your application is going to do and who your intended target is (who will be using it). Then we will be able to provide more accurate advice.
RPalmer
http://msdn.microsoft.com/vstudio/express/sql/
Otherwise, I use SQL Server.