Are there anyone of you out there who can give a link to a good cook book on how to use stored procedures in C#??? Please help!

> Are there anyone of you out there who can give a link to a good cook book on
> how to use stored procedures in C#??? Please help!
>
A quikly googled it and theres some stuff...
HERE...try that....no specific books that i know of but sometimes the online guides can help for a short term problem or a quik fix...

---

<BR>AMD XP3200+
<img src="http://boinc.mundayweb.com/seti2/stats.php?userID=2327&amp;trans=off"><img src="http://petrus.homeftp.org/bws/counter_big.php?id=7828479">
<a href="http://homepage.ntlworld.com/paulandrew.odell/">MY SITE!</a>

> A quikly googled it and theres some stuff...
> HERE...try
> that....no specific books that i know of but sometimes the online guides can
> help for a short term problem or a quik fix...
>

Thanks! I already have googled and came up with the same results and have printed out some code. But if somebody out there knows about a specific book or link, please let me know!

> Are there anyone of you out there who can give a link to a good cook book on
> how to use stored procedures in C#??? Please help!

Well, the FIRST think I would like to know is which database. I know Oracle Stored procedures, and a little about MS SQL Server (blegh!), but the books would be quite different ...

Also, you may want to just think about triggers ... then you don't need to worry about invoking a stored procedure, the action against the table "fires" the trigger and the Bob's your uncle and off you go ...

The two primary reasons that you do SP or triggers is to automate database behaviors regardless of the source of the action. Also, when applied, SP/Triggers are generally faster than code written in any language.

Though, I will point out also, that using an OO language against a relational database also has to be concerned about the "friction" that exists between procedural context and OO context ... though Oracle in the 10+ versions now does also have OO capabiities ...

---

> > Are there anyone of you out there who can give a link to a good cook book
> on
> > how to use stored procedures in C#??? Please help!
>
> Well, the FIRST think I would like to know is which database. I know Oracle
> Stored procedures, and a little about MS SQL Server (blegh!), but the books
> would be quite different ...
>

It's a WinKompas 3 database. A Danish economic management system, which is used by a lot of Danish companies.

> Also, you may want to just think about triggers ... then you don't need to
> worry about invoking a stored procedure, the action against the table "fires"
> the trigger and the Bob's your uncle and off you go ...
>
> The two primary reasons that you do SP or triggers is to automate database
> behaviors regardless of the source of the action. Also, when applied,
> SP/Triggers are generally faster than code written in any language.
>

And my employer wants me to do SP, as they will "cover it all" in a table, and the product I'm working on is supposed to be sold for different purposes. So He doesn't want me to create procedures just for the task, I'm working on right now!

> Though, I will point out also, that using an OO language against a relational
> database also has to be concerned about the "friction" that exists between
> procedural context and OO context ... though Oracle in the 10+ versions now
> does also have OO capabiities ...
>

I know that very well! But I have earlier succeded in creating functions in classes to manipulate databases. It's a kind of semi OOP! But, you're right, it's a kind of walk over the river to swim!

> It's a WinKompas 3 database. A Danish economic management system, which is
> used by a lot of Danish companies.

I have never heard of that one ... then again, I have never been to spain either. Is that a proprietary database? Or do they run it ON something like Oracle? AH! The wonders of the Internet. Ok, i found a book and the key you NEED to start looking is in this " Microsoft SQL 2000 Desktop Engine" (<a>).

So, question one is, can that database engine do stored procedures. Then two, what is a good book for that. The bad news from me is that I can't help you. Other than to suggest you get a "real" database ... :)

Ok, seriously, mostly all you need is the syntax of the stored procedures so that you can write them, the rest is just programming using good programming practices. The books I once had (when I was still working) for SQL Server and that ilk, I was not too thrilled with any of them. So, maybe you have better information as a start place to continue the hunt.

---

> I have never heard of that one ... then again, I have never been to spain
> either. Is that a proprietary database? Or do they run it ON something like
> Oracle? AH! The wonders of the Internet. Ok, i found a book and the key you
> NEED to start looking is in this " Microsoft SQL 2000 Desktop Engine" (<a>).
>

It's based on MSSQL. And it's a relational database!

> So, question one is, can that database engine do stored procedures. Then two,
> what is a good book for that. The bad news from me is that I can't help you.
> Other than to suggest you get a "real" database ... :)
>

Small businesses can't afford to spend 10,000 - 15,000 $ on a license to an Oracle database, :-( so many prefer a product like the above! A full funktional economic management system. And yes, it supports stored procedures. Actually a lot of SP goes with the database. And it's some of these, my employer wants me to use, instead of building a database and create the procedures myself.

> Ok, seriously, mostly all you need is the syntax of the stored procedures so
> that you can write them, the rest is just programming using good programming
> practices. The books I once had (when I was still working) for SQL Server and
> that ilk, I was not too thrilled with any of them. So, maybe you have better
> information as a start place to continue the hunt.
>

I got [url=http://www.c-sharpcorner.com/Code/2005/Jan/DataAccessLayerforcallingSP.asp]this link<a> from Timmy aka Captain Avatar this morning, and this was just the syntax I needed and was looking for!

Thank you, Timmy!

> Are there anyone of you out there who can give a link to a good cook book on
> how to use stored procedures in C#??? Please help!
>
Maybe my answer is a bit late but ... Yup, there are some good resources on the net. Take a look at www.asp.net and look at the "starter kit" section. You'll find some interesting web application, considered as Good Practice code from Microsoft. Install "Portal Starter Kit" and you will find loads of examples have to use SP's using C#.

---

Happy crunching

> > Are there anyone of you out there who can give a link to a good cook book
> on
> > how to use stored procedures in C#??? Please help!
> >
> Maybe my answer is a bit late but ... Yup, there are some good resources on
> the net. Take a look at www.asp.net and look at the "starter kit" section.
> You'll find some interesting web application, considered as Good Practice code
> from Microsoft. Install "Portal Starter Kit" and you will find loads of
> examples have to use SP's using C#.
>

Yes I have started to use the class from the link above, and it's working good so far! I haven't started to test the stored procedures, I need, yet, so that'll be next week! But thanks a lot! I can always use links to good programming sites!


I'm working home next week, so I have brought my workcomputer with me at home! It has a 17'' widescreen in it, so I plan to watch my The Lord of the Rings extended dvd's on it! :-) It has a tv card in it too, so.... :-))))!

---