question about database

why do we use the app server to host a mysql database ?
why do we use nhibrinate or subsonic or ado.net or any Object/Relational-Mapper solutions for accessing that database ?

why don't we use the microsoft integrated local(compact) and express databases within the visual studio

what is the alternatives for stuff i've mentioned above (like why not we use another RDMS than mysql or another language than sql) , why not we use ms sql studio than navicate

it's kinda embarrassing to ask but more embarrassing to stay stupid :) sorry i couldn't just take it as it is and use it without proper understanding of the concept

Cleaned. Please stay on topic.

There are a lot of different query languages, and there are a lot of ways to manage those languages. MySql and Microsoft's SQL language seems to be the top two in this community. They're both good, but Microsoft's SQL language has optimizations for C# and their .NET languages, so it's slightly faster. They're still both very good. Now, as far as managing databases written in those languages, a popular way to go is object-relational-mapping. You can easily create a relational mapper, but there are some very good ones that a lot of people here use (such as NHibernate and Subsonic). The idea behind object-relational-mapping is that rows are read in and parsed as objects (rather than reading in one column at a time like Impulse's source did). It allows for more tasks to be done using less transactions per task. Hopefully that's what you were asking about. Good luck.

Edit: Also, you should try not to use appserv. It's out of date by a few years now. You can download each service appserv offers (such as [Only registered and activated users can see links. Click Here To Register...]), or you can download something similar... like [Only registered and activated users can see links. Click Here To Register...]. Navicat is just a tool used to view your database (it's not a language or service).

Quote:

Originally Posted by Fang Cleaned. Please stay on topic. There are a lot of different query languages, and there are a lot of ways to manage those languages. MySql and Microsoft's SQL language seems to be the top two in this community. They're both good, but Microsoft's SQL language has optimizations for C# and their .NET languages, so it's slightly faster. They're still both very good. Now, as far as managing databases written in those languages, a popular way to go is object-relational-mapping. You can easily create a relational mapper, but there are some very good ones that a lot of people here use (such as NHibernate and Subsonic). The idea behind object-relational-mapping is that rows are read in and parsed as objects (rather than reading in one column at a time like Impulse's source did). It allows for more tasks to be done using less transactions per task. Hopefully that's what you were asking about. Good luck. Edit: Also, you should try not to use appserv. It's out of date by a few years now. You can download each service appserv offers (such as [Only registered and activated users can see links. Click Here To Register...]), or you can download something similar... like [Only registered and activated users can see links. Click Here To Register...]. Navicat is just a tool used to view your database (it's not a language or service).

thank you for your time and for such information, but still i would love to ask something

first :
regard the object relational mapper, if i can praise the data from database to an object safely and efficiently to an objects would i still need one ? i'm spending weeks now to master linq/anonymous types/lambada for such an approach, would that do the trick ?

second :
why do i need to have the appserv or any of it's updated alternatives ? is that releated to phpmyadmin and such that host connection between database on certain port with the applications ?

third :
how to create a mysql database and make it functional

im sorry once more but knowledge is tempting me to ask more, thanks for not just passing by like everybody else :)

Quote:

Originally Posted by i picked the red pill too thank you for your time and for such information, but still i would love to ask something first : regard the object relational mapper, if i can praise the data from database to an object safely and efficiently to an objects would i still need one ? i'm spending weeks now to master linq/anonymous types/lambada for such an approach, would that do the trick ? second : why do i need to have the appserv or any of it's updated alternatives ? is that releated to phpmyadmin and such that host connection between database on certain port with the applications ? third : how to create a mysql database and make it functional im sorry once more but knowledge is tempting me to ask more, thanks for not just passing by like everybody else :)

An object relational mapper just takes a row (or multiple rows) from a database, then uses a map of the table to map values to fields in the object you defined. I created my own in the C++ project I released, but it was extremely basic (I used enumeration types to parse the row into the object). If you can do that without a mapper, that's fine. I find NHibernate to be a great, flexible mapper though (which is why I use it).

AppServ is just a collection of services. It contains PHP and MySQL, but as I said... they're very out of date because AppServ hasn't been updated in years (last updated in 2008 I believe). That's absolutely ancient in database management service updates. As far as a MySQL database, I'm sure there are tutorials everywhere. I know there are because I had to look them up for C++. Try looking into sources here as well (if you want to do it in C#).

AppServ is outdated. I used (before using separate things) WAMP, which is still kind of up-to-date. (Apache : 2.4.4 MySQL : 5.6.12 PHP : 5.4.12 PHPMyAdmin : 4.0.4 SqlBuddy : 1.3.3 XDebug : 2.2.3) It could be a good alternative if you don't want to setup everything.

AppServ 2.6.0 (last version) contains Apache 2.2.8, PHP 6.0.0-dev, MySQL 6.0.4-alfa, phpMyAdmin -2.10.3. Basically, unstable packages with outdated ones... AppServ 2.5.10 contains Apache 2.2.8, PHP 5.2.6, MySQL 5.0.51b, phpMyAdmin -2.10.3.

And as for Windows, if you don't want to use seperate packages, use Wamp or Xampp.

Quote:

Originally Posted by turk55 And as for Windows, if you don't want to use seperate packages, use Wamp or Xampp.

Edited. I wanted to say WampServer :p I've never used MAMP on OS X as Apache & PHP are already in the OS...

There's no requirement for you to use AppServer, or any packages such as Xamp, Wamp, Mamp, etc. I never have, they are normally more trouble than they are worth.