How to call SQL Function directly from CodeSmith generated service dlls

Question

In a project we are using CodeSmith to generate database layer, Codesmith seperate creates service classes for each SQL View and SQL Table, using these service classes we can call StoredProcedures that has prefix "ViewOrTableName".

My problem is that I am unable to directly call any storedprocedure/view or function.

If any body atleast know how to call a function and get response please let me know

Thanks, Imran Rizvi

Blake Niemyjski · Accepted Answer · 2012-04-16T14:29:23.737

0

I'm assuming that you are using the .netTiers templates. You would need to access the view or stored procedure data (result set) via the component layer (http://www.nettiers.com/ComponentLayer.ashx). You should have methods that are generated for views and stored procedures once you select a view to generate / enable support for custom stored procedures while configuring the generation options (http://www.nettiers.com/Database.ashx).

edited Apr 16 '12 at 14:29

answered Apr 11 '12 at 17:36

Blake Niemyjski

3,432
3
25
41

No , I don't want to name SP with prefix of _View/Table_ name and directly want to call it , it seems that is not possible. – Imran Rizvi Apr 17 '12 at 05:42
You don't have to, there is a property you can set for the name matching format.. – Blake Niemyjski Apr 17 '12 at 19:59

How to call SQL Function directly from CodeSmith generated service dlls

1 Answers1