Export to GitHub

subsonicproject - issue #105

Stored Procs - Schema Names Issues


Posted on Jun 23, 2009 by Grumpy Panda

What steps will reproduce the problem? 1. In one of the databases, we have two procs that are the same except for the schema name. The code generates two proc interfaces with the same parameters.

What is the expected output? What do you see instead? It would be nice to see all the 'dbo' procs in the main class with the non- dbo versions in a schema subclass. For example: dbo.p_MyProcName --> StoredProcedures.MyProcName Inventory.p_MyProcName --> StoredProcedures.Inventory.MyProcName

This would correct the issue and setup a logical subset of the procs.

What version of the product are you using? On what operating system? 2.2

Northwind Unit Test to verify the problem:

Status: New

Labels:
Type-Defect Priority-Medium