Configuring build agent without install

[luke_rdr]

Hi,
Please could you advise us on what steps are required to configure a build agent (TFS Team Build/MSBuild) to be able to build applications that use dotConnect for SQLite (code generation and assembly resource embedding from EDML files). Is there any way we can avoid having to run the installer, add assemblies into the GAC and alter the machine.config?
Thanks,
Luke

[Shalex]

As you want to avoid installing dotConnect for SQLite on build server, you should:

1) compile the license resource manually on a development computer (where dotConnect for SQLite is installed), and then copy it to build server and attach it to your project as an Embedded Resource

2) create Devart Entity Model (*.edml) and generate code using a standalone Entity Developer (Start > All Programs > Devart Entity Developer > Entity Developer) on a development computer. Then add the generated code/mapping files instead of *.edml itself to your project on build server

3) copy the needed Devart.* assemblies to your project on build server

If this information doesn't help, please specify the exact text of the error and its call stack you are getting on your build server.

[smuddasu]

What should be in the connectionString? should it still have the references to metadata ?
For example,
<add name="MeetingListEntitiesConnectionString" connectionString="metadata=res://MeetingListService/MeetingListModel.csdl|res://MeetingListService/MeetingListModel.ssdl|res://MeetingListService/MeetingListModel.msl;provider=Devart.Data.Oracle;provider connection string="User Id=demouser;Password=demopassword;Server=demoserver;Persist Security Info=True"" providerName="System.Data.EntityClient" />

[Shalex]

to smuddasu

If you set Metadata Artifact Processing=Copy To Output Directory in your *.edml, the connection string would be:

Code: Select all

<add name="MeetingListEntitiesConnectionString" connectionString="metadata=.\MeetingListModel.csdl|.\MeetingListModel.ssdl|.\MeetingListModel.msl;provider=Devart.Data.Oracle;provider connection string="User Id=demouser;Password=demopassword;Server=demoserver;Persist Security Info=True"" providerName="System.Data.EntityClient" />