Some Beginner Questions

Question

User-1324547140 posted

Hi,

Sorry if I post this at the improper place, I actually don't know how to categorise these questions.

I am new to Visual Studio Community Ver 7.3.3 (build 23) Mac version. I am starting to develop a Web project using Web Form. At some point, I need to create database and tables to store data. However, I don't know where to start. All the guides and step-by-steps are not really useful to me as I couldn't follow those steps because I couldn't find the related item/step in my VS Community. Also my project workspace's ToolBox does not have any database or data source items to add.

Can anybody generously point me to any beginner guides to configure or setup database in a project?

I found many SQL packages in NuGet, which one should I install in order to setup database for my project?

Answer 1

User1120430333 posted

https://en.wikipedia.org/wiki/Separation_of_concerns

Layered vs n-tier

https://msdn.microsoft.com/en-us/library/ee658117.aspx

https://msdn.microsoft.com/en-us/library/bb384398.aspx

https://www.codeproject.com/Articles/228214/Understanding-Basics-of-UI-Design-Pattern-MVC-MVP

https://docs.microsoft.com/en-us/aspnet/core/

https://docs.microsoft.com/en-us/ef/core/

https://www.codeproject.com/Articles/1155738/NET-Core-On-Mac-Building-An-ASP-NET-Core-App-With

Answer 2

User409696431 posted

DA924, Since the question is about Web Forms, links to Core are not relevant.

KWCham,

Visual Studio  Mac version does not support localdb (the default VS-created database type), and MAC doesn't support the standard SQL server installation.  You need to use a different version of SQL server, and put its connection string into your web.config.  Since Web Forms will only run on a Windows server, I assume that if you publish anything you develop now, it will be to a Windows server, so MS SQL Server is a reasonable choice of database.   You'll need to work with SQL Server 2017, which has a way to run on a MAC.

SInce I don't use a Mac, I won't be able to help if you have problems, but start here: http://database.guide/how-to-install-sql-server-on-a-mac/ 

Answer 3

User1120430333 posted

DA924, Since the question is about Web Forms, links to Core are not relevant.

Why not? It's a viable path that should be looked at, and maybe,  the OP should abandon ASP.NET Web forms if looking to go across platform to Mac using .NET.

Answer 4

User409696431 posted

The question was about a database for Web Forms, not about which flavor of Asp.Net to use.  That's a valid, but very different topic.

Answer 5

User1120430333 posted

The question was about a database for Web Forms, not about which flavor of Asp.Net to use.  That's a valid, but very different topic.

The topic was about Beginner, which tells me that the OP doesn't know too much about anything. And the OP should have picked-up on what database he could use on the MAC that .NET can use, which is NOT MS SQL Server.   So what that it's Core?  But Core is showing what can be done and not what cannot be done.

Answer 6

User409696431 posted

"And the OP should have picked-up on what database he could use on the MAC that .NET can use, which is NOT MS SQL Server." 

Apparently you did not read my reply to the OP.  You can use SQL Server 2017 on the Mac.  There is a download for that.

Answer 7

User1120430333 posted

"And the OP should have picked-up on what database he could use on the MAC that .NET can use, which is NOT MS SQL Server." 

Apparently you did not read my reply to the OP.  You can use SQL Server 2017 on the Mac.  There is a download for that.

Yes, your post was unimportant to me and I didn't read it. 

Answer 8

User-1324547140 posted

Hi Kathy,
Thanks for the reply. Now I understand why. Appreciate your help. :)

Appreciate your reply on the SQL Server 2017. I will try setup that.

Hi guys,

I don't want to stir up any argument or any quarrel here in this forum. So can you guys be cool? :)

DA924: Your links are very useful for the architecture of the my project, I really appreciate your help too. :)

Answer 9

User1120430333 posted

There you have it. I am more into developing the solution effectively architecture. Anyone can write some code, but can one architect is the key.