n tier architecture with LINQ to SQL
Posted: Sun 13 Oct 2013 11:53
Hello
I have a working WPF application where i use the Devart LinqConnect model to work directly with my database. However due to circumstances I now need to connect to the database via another application/service located elsewhere
I first thought of creating a WCF service which communicated with the database with LINQ and then returned the data to my WPF. However I get the error that the connection string can not be found in the configuration file.
What is the best approach to solve this problem? If possible can you send a sample solution showing how to get data from a database via another application?
Regards
Edits:
I seem to have solved my issue by changing the service to use tpc instead of the default http. Is this the correct approach?
I have a working WPF application where i use the Devart LinqConnect model to work directly with my database. However due to circumstances I now need to connect to the database via another application/service located elsewhere
I first thought of creating a WCF service which communicated with the database with LINQ and then returned the data to my WPF. However I get the error that the connection string can not be found in the configuration file.
What is the best approach to solve this problem? If possible can you send a sample solution showing how to get data from a database via another application?
Regards
Edits:
I seem to have solved my issue by changing the service to use tpc instead of the default http. Is this the correct approach?