|
 Thursday, October 12, 2006 |
| Foxpro stored procedures from .NET |
|
I was recently faced with the task of integrating a .net web application with a foxpro database. Due to the specific requirements of the project, the integration had to be written in a .net language. Even though the integration was just performing CRUD operations (create, read, update, delete), at several points during the design phase, I kept thinking "Man, this would be easier in foxpro!". In some cases, an operation that would take .net 10 lines of code could be accomplished in just 3 lines of FoxPro.
After much research and experimentation, it turns out the FoxPro OleDb driver will allow you to call stored procedures that are actually foxpro .prg files! Essentially, you can create functions or procedures in foxpro, call the program from the .net app (using standard sql syntax and passing any parameters necessary), and return values to the .net app as needed. This opens the door to many interesting possibilities... |
jeremy at 2:05 AM |
(0) Comments
|
Add a comment |
Permalink
|
|
|
|