DbService

/ Assembly List / LJCDBServiceLib / DbService

Namespace - LJCDBServiceLib

Syntax

C#
public class DbService : IDbService

The Service Type for performing database operations using database query XML messages. (RE)

Public Methods

Execute

Executes the specified request XML message.

1 Methods

Private Methods

#ctor

Initializes an object instance.

1 Methods

Properties

UseEncryption

Gets or sets the UseEncyption flag.

Example

The DbService can be hosted in a windows service or web service which could run on a separate server machine.

C#
// The DbService object retrieves the data configuration from a file named // "DataConfigs.xml". This file must be in the same folder as the application. // This is the XML file layout. <?xml version="1.0"?> <DataConfigs xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <DataConfig> <Name>PersonData</Name> <DBServer>Machine_Name\SQL_Instance_Name</DBServer> <Database>Database_Name</Database> <ConnectionType>SQLServer</ConnectionType> </DataConfig> </DataConfigs>

// The DbService object retrieves the data configuration from a file named
// "DataConfigs.xml". This file must be in the same folder as the application.
// This is the XML file layout.

<?xml version="1.0"?>
<DataConfigs xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <DataConfig>
    <Name>PersonData</Name>
    <DBServer>Machine_Name\SQL_Instance_Name</DBServer>
    <Database>Database_Name</Database>
    <ConnectionType>SQLServer</ConnectionType>
  </DataConfig>
</DataConfigs>