[SOLVED] How to use Entity Framework witk Sharepoint Custom Timer Job?

How to use Entity Framework witk Sharepoint Custom Timer Job?

I developed a SharePoint Custom Timer Job which reaches SQL Server by Entity Framework. So normally EF uses SharePoint application's web.config AppSettings to get the ConnectionString it needed. But, in this case, where Custom Timer Job reaches SQL Server via EF, it gives me

The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid.

It is obvious that it can't read ConnectionString value from configuration.

QUESTION:

Do you guys know where is this SharePoint Customer Timer Job's configuration file is? SharePoint Administration application web.config? machine.config? Feature.xml of Feature?

If it doesn't read this info from a config file, what should I do to access ConnectionString of EF? Use properties of Custom Timer Job to persist ConnectionString information?

Solution

SP job timer is executed by the SP timer job window service. The exe is Owstimer.exe located in the bin folder. You can add to or created Owstimer.exe.config so that your custom job can read from it.