(3) configuration of connecting to MySQL database with subsonic

Add subsonic. dll references to the project;

Add

<Configsections>
<Section name = "subsonicservice" type = "subsonic. subsonicsection, subsonic" requirepermission = "false"/>
</Configsections>

<Connectionstrings>
<Clear/>
<Add name = "mysqldataconnection" connectionstring = "Data Source = dataserveripornamepipe; database = database; user id = username; Password = password"/>
</Connectionstrings>
<Subsonicservice defaultprovider = "mysqldata">
<Providers>
<Clear/>
<Add name = "mysqldata" type = "subsonic. mysqldataprovider, subsonic" connectionstringname = "oracledataconnection" generatednamespace = "mysqldatadomain"/>
</Providers>
</Subsonicservice>

Then subsonic Dal, refer to http://hi.baidu.com/beloving/blog/item/472d17ce1ed17e3ab600c8a9.html

NOTE: If there are multiple databases or even multiple types of databases in the same project, such as SQL SERVER + Oracle + MySQL, different namespaces are recommended, in this way, multiple corresponding folders will appear in the generated directory to store the corresponding data classes.