C# ASP.Net MVC API Web App Using Advanced DB Master as a Data Source

Been wondering how to build a C#, ASP.Net, MVC, API web app using ADBM (Advanced DB Master) data source on the back end?  You’re welcome.

Demo source on GitHub.

Install Advanced DB Master (ADBM) from http://maconsys.com then open the Sample database, ADBMSamp, and exit ADBM.

ADBM added a System DSN ODBC datasource called adbmsamp to your OS.

SystemDSN.PNG

In Visual Studio, create a C# ASP.Net Framework or Core Web Application.

VisualStudioProject.PNG

And select Web API, leaving the MVC and Web API boxes checked.

WebAPI.PNG

Optionally, you can add the data source as a database connection and work with it that way if you prefer, but that’s not necessary.

DatabaseConnection.PNG

For our needs we’ll just need a connection string in the web.config:

<connectionStrings>
<add name=”csADBMSamp” connectionString=”DSN=adbmsamp” />
</connectionStrings>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s