Has anyone had any success with Subsonic3, linq, MySQL and Stored Procedures?

I have never got stored procedures to work for mysql and subsonic, but I havent tried so hard either. My reasoning behind that you have something better than inline sql I think I speak for the masses that stored procedures was used to get around having database code (loads of sql) inside the application, dotted here n there so programmers would use stored procedures to seperate the 2 concerns and make it easier to update/change/repair now if you use subsonic or any other kind of DAL and entities then you have no need to write sql statements as such, you just write code.... subsonic, linq etc know what to do with that and translate it for you so you don't really need stored procedures, if your database has a problem, you just run your TT files again the rest is code, your program. So maybe it is not the answer you would like, but sack the stored procedures and make use of how much fun it is to use something like subsonic and well forget all about your database and just think about the code.

I have never got stored procedures to work for mysql and subsonic, but I havent tried so hard either. My reasoning behind that you have something better than inline sql. I think I speak for the masses that stored procedures was used to get around having database code (loads of sql) inside the application, dotted here n there so programmers would use stored procedures to seperate the 2 concerns and make it easier to update/change/repair.

Now if you use subsonic or any other kind of DAL and entities then you have no need to write sql statements as such, you just write code.... subsonic, linq etc know what to do with that and translate it for you. So you don't really need stored procedures, if your database has a problem, you just run your TT files again. The rest is code, your URL1 maybe it is not the answer you would like, but sack the stored procedures and make use of how much fun it is to use something like subsonic and well forget all about your database and just think about the code.

Good point. I agree totally.. I am building a data layer on someone elses db and he had some hefty stored procedures written that I just didn't have time to reproduce in object code. So running his existing stored procedures was the quickest option for me.

– craig Oct 26 '09 at 10:37.

I had a problem executing a SP with no parameter and trying to read back ouput. Seems you have to do this work around; SubSonic. StoredProcedure sp = SPs.UspNoParamProc(); //Stored Procedure command Is Null... ensure command is created string dummy = sp.Command.

CommandSql; rptList. DataSource = sp.GetReader(); rptList.DataBind(); Not sure if this problem continues to exist in 3.0 or not. Might try it out.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.