SubSonic – Non-Crud Stored Procedures

subsonic

I want to create a Data Access Layer for a small application. The stored procedures have previously being created and are not basic CRUD ones. Most are quite custom and don't really map one-to-one to tables in the database. I also need concurrency support.

Can SubSonic / SimpleRepository handle this for me?

Best Answer

I don't think SimpleRepository will work well in this situation. You might find the LinqTemplates work well to query the data. Subsonic also does a good job handling sprocs and makes it easy to return datasets, or typed results if you have classes that match the structure of your sproc resultsets.

For example, you can map the results of a sproc to a List like this:

StoredProcedure sproc = _db.GetProductList();
List<Product> products = sproc.ExecuteTypedList<Product>();

All matching columns that can be populated will be.

Related Solutions

R – SubSonic and Stored Procedures

If the results of the stored procedure has the same schema as one of your tables, you can build a collection using this code (SubSonic 2.1):

ProductCollection coll = new ProductCollection();
coll.LoadAndCloseReader(SPs.GetProducts(1).GetReader());

Could not find server ‘dbo’ in sys.servers

Please run select name from sys.servers from the server which you mentioned as default server in configuration file.

Here in name column values should match with your server names used in the report query.

e.g serverXXX.databasename.schema.tablename

serverXXX should be there in the result of select name from sys.servers otherwise it gives error as got.

Best Answer

Related Solutions

R – SubSonic and Stored Procedures

Could not find server ‘dbo’ in sys.servers

Related Topic