Question

C# questions. Had trouble finding info on these questions. Looking for some input.

1. In our examples, we are connecting a C# application to a back-end database. What kind of database are we using? Could we connect to other back-end databases using C#. Why would you want to do this?
2. We will use ADO.NET and the Entity Data Model. Are there other ways to connect to this and other back-end databases? Why might you want to use other connectivity methods?
3. In the “real world”, a back-end database might contain numerous simultaneous connections. Some connections could come from web-based users, and some from desktop users, and some from mobile users. Can you think of situations in which this would occur?

Answer 1

As per the requirement submitted above , kindly find the below solution.

Question 1:

In C# applications are using back-end database to store and to get information.
This database might be SQL Server database because .net is microsoft product and most appropriate database to connect application is SQL Server.
Both .net and SQL Server is given by microsoft.
In C# application can use different databases like Oracle , MySQL etc.
Connection of application with other database like oracle and mysql is totally depends on applications requirement.
Because whatever capabilities and functionality oracle and mysql provides same kind of functionality sql server provides.
**********************************

Question 2 :

In .net whenever there is requirement to connect application with database either ado.net or Entity data model is used.
Entity data model is kind of ORM that can created an database design as per application needs.
Apart from these two there is no another way to connect to any backend database applications like sql server , oracle or mysql etc.
**************************************

Question 3:

Now a days business are running from web , mobile and iot applications.
For an application some users might access it from desktop based browser or mobile.
Suppose some people might access amazon from desktop browser , some from mobile browser or some other can access from IOT applications.
So your backend database can be capable of handling all these requests.
One solution to these implement RESTful Service that is Web API in case of .net.