AnantLabs / codesmith

Automatically exported from code.google.com/p/codesmith
1 stars 0 forks source link

PLINQO - C# generation does not generate functions in Models folder. (*Functions are generated in .dbml) #685

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
- MK: SEE LETTER TO BLAKE BELOW-

What is the expected output? What do you see instead?
- MK: Generate functions in the Models folder.

What version of the product are you using? - MK: CodeGenerator 6.5.1 Pro 
Revision 14716. Templates -r2950 in local project. QuickStart to start project 
generated with the Templates shipped in 14716. 

Please provide any additional information below.
LETTER TO BLAKE

I've run into another issue that I can't seem to resolve. I am unable to 
generate Functions (not sure about stored procedures) from a project I have. 
The settings are exactly the same as another project where the Functions 
generate as expected into the Models folder. The only difference between this 
project and the successful one is that I am generating C# vs. VB. 

1) The database server is the same and uses the same login.

2) The database is on the same server (point 1) and grants the same user (same 
as the successful generated project) with the exact same permissions. (read, 
write, execute - I doubt this could be the problem since the functions are 
being created properly on the .dbml file).

3) The .dbml file contains the functions but nothing will generate into the 
Models folder. (I manually created this.)

4) Manage Outputs > DBML > Generate Functions is checked.

5) Manage Outputs > Entities > Model Directory = .\Models (All settings in this 
csp file are exactly the same as the successful project- only difference is 
this uses the C# templates)

6) After all else failed, I downloaded plinqo - r2950 and replaced the CSharp 
templates and replaced the ones in my project. *Manage Outputs > All .cst paths 
point to my project templates.

Original issue reported on code.google.com by markku...@yahoo.com on 8 Mar 2013 at 6:50

GoogleCodeExporter commented 9 years ago
Futher investigation - 
I was able to generate a project using the same c# templates from our first 
successful sql database so it does not appear to be something related to the C# 
templates. All of the functions appear as expected. There appears to be some 
difference between the two sql databases but it is the same user with the same 
roles.

Have you heard of anything like this?

Original comment by markku...@yahoo.com on 8 Mar 2013 at 8:38

GoogleCodeExporter commented 9 years ago
I have not, but I'd recommend using a tool like Red-Gate sql compare and do a 
diff between the two databases. This will help see what is causing this issue.

Original comment by bniemyjski on 8 Mar 2013 at 9:32

GoogleCodeExporter commented 9 years ago
I discovered the issue. Scalar Value Functions are not being generated. 

Is this going to be suported in a future release? 

I'll have to convert these to stored procedures, which is OK. 

Original comment by markku...@yahoo.com on 8 Mar 2013 at 9:46

GoogleCodeExporter commented 9 years ago
Hello,

Can you please send support your svf definition along with any dependencies so 
I can take a closer look. It might have to do with the definition.

Original comment by bniemyjski on 11 Mar 2013 at 7:49