I currently have a webservice that my applications talk to, to get data from the database. See below.
How would I implement this using open access? I have already created a class library that reversed mapped my database and added that as a reference to my webservice. I have also enabled open access on my webservice and have a ObjectScopeProvider1 class.
How would I get this data and still return as dataset.VB or C# example would ok.
Public Function Get_Application_FolderPath() As DataSet
Dim ds As New DataSet
Using conn As New MySqlConnection(MySQLDBString)
' conn.ConnectionString =
Dim cmd As New MySqlCommand("Select * from applicationFolderPath", conn)
cmd.CommandType = CommandType.Text
Dim da As New MySqlDataAdapter(cmd)