I am trying to move a PowerBuilder process that is almost all Computational Business Logic. I am starting from a Command Line Tool C# project rather than a WebServer (RestAPI) and have harvested over the Business Logic and Data Models, pretty well. In all of the Tutorials that I can find, the starting point is an ASP.NET project and it's seems to me that the Database Connection to SQLServer is being done by "magic" middleware of the ASP.NET project. I did find some references in the SnapObjects Documentation for getting a connection SqlServerDataContext.SqlServerDataContext() but I'm stuck using the example finding how to have SqlServerConnection visible in the code
... new SqlServerConnection(CONNECTION_STRING)
I am new to PowerBuilder and .NET, so trying to start with just getting a Database Connection to the
SQLServer Database (which I am able to connect to in order to convert the PowerBuilder to C# on my Dev box.
Any References to Full Examples or a Tutorial using DataStore that is NOT using ASP.NET would really help.