Web Services and datasets

[Paul]

Hi,
    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

 

'cmd.Parameters.Add("UserName", UserName)

 

 

Dim da As New MySqlDataAdapter(cmd)

 

conn.Open()

ds.Namespace =

"FolderPath"

 

ds.Prefix =

"Folders"

 

da.Fill(ds,

"Folders")

 

conn.Close()

 

End Using

 

 

Return ds

 

 

End Function

 

[Alexander]

Hello Paul,

OpenAccess has its own disconnected API and you do not need to use DataSets. You should use the ObjectContainer class instead. It has the same API as the ObjectScope - you can create, modify and delete objects but without the need of a constant connection to the database. A ChangeSet class is used for filling and extracting data from the container. The class is serializable and can be used for transmitting the data through the service. For more details please take a look at this example.

Kind regards,
Alexander
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.