Dear Friends,
I am developing a Web Service in Visual Studio 2008 (3.5 SP1). The web service will connect to a MySQL database and retrieve information based on certain parameters. Being that the MySQL database is 4.2.X, I am aware that I cannot create new queries and stored procedures (please correct me if I am wrong).
I have built a query in dbForgeFusion for MySQL and would like to use it (or something similar) to execute the SQL itself as I DO NOT want to embed SQL statements directly into my web service code behind file (.CS). I have examined the "Web Service" sample that comes with dotConnect for MySQL and it displays exactly what I don't want to see: SQL statements embedded in the code.
Is there a method or process to build an SQL query and then use it to strongly type the results instead of having to embed SQL statements directly into my code.
Best Regards,
Giovanni
Strongly Typed Query
Binding to SQL Queries in Entity Develop
Hi,
While I begin my possible endeavour into Entity Developer for MySQL, I do not see an obvious, if at all possible way, to connect to a simple SQL query with parameters. I know I can bind to stored procedures bu this requires an update of my client's MySQL server which is currently at 4.2.1 and subsequently does not have the ability to create and use stored procedures. Any workarounds possible. I have the SQL quyery, I just need to bind to it as you would a stored procedure and have the appropriate classes/entity classes generated as is currently available for database tables and stored procedures?
Giovanni
While I begin my possible endeavour into Entity Developer for MySQL, I do not see an obvious, if at all possible way, to connect to a simple SQL query with parameters. I know I can bind to stored procedures bu this requires an update of my client's MySQL server which is currently at 4.2.1 and subsequently does not have the ability to create and use stored procedures. Any workarounds possible. I have the SQL quyery, I just need to bind to it as you would a stored procedure and have the appropriate classes/entity classes generated as is currently available for database tables and stored procedures?
Giovanni