Hi,
I'm using .netTiers 2.2.0 rev 705 and there is a problem with the generated code when you have a View that belongs to a different schema that dbo. The procedure code its OK, but the code that calls the procedure in application omits the schema of the procedure, causing errors.
So, based on file SqlEntityProviderBase.generated.cst, I made some corrections in file .\DataAccessLayer.SqlClients\Views\SqlEntityViewProviderBase.generated.cst to prevent these errors:
In the beggining:
//Get the owner of the table
string owner = GetOwnerName(SourceView, true);
And every time when procedure is called, just add the owner varible. Example:
DbCommand commandWrapper = StoredProcedureProvider.GetCommandWrapper(database, "<%=owner + ProcedurePrefix + GetCleanName(name) + SelectSuffix + SelectAllSuffix%>", _useStoredProcedure);
I hope this can be useful. By the way, thanks very much for .netTiers template!
André