title: Structural/ conceptual advice on working with custom functions for SQL database from C#
body: <p>I'm wondering if any seasoned C#/ SQL developers could give me a nudge in the right direction as I get started with a new project. I'm coming from an MS Access/ VBA world, and I'm trying to develop a market- data system with C#, SQL server express back= end. My main question is what is the best way to work with custom functions? In access/ vba, it was simple to write udfs, and then nest them as deeply as I needed to continue creating new functions. So in C#/SQL, should I have a static functions class in C#? Or pass @parameters to SQL? It doesn't seem as straightforward to me to work with the database from my application. As always thanks in advance...</p>