I thought this post might be useful for the LINQ/BLINQ dev's (if they monitor this community) or anyone else having a problem generating an app ...

I installed May CTP of LINQ and BLINQ had an old stored procedure that does some maintenance on SQL foreign keys (see below).

When generating my WebApp I got an error. I tried running the compiler command, which displays a load of C# compiler errors related to my stored procedure. Clearly since I am using system objects in the procedure, there seemed to be a conflict in property names ... (since the procedure is old and not required I simply deleted the procedure ... however, it may be an indication that some different property naming is reuiqred within LINQ or BLINQ!???

BLINQ command line:

blinq /t:C:\Work\Blinq\CRISP /pageDataSource /server:WR-DEV2005 /database:CRISP /namespace:BlinqCrisp /vDir:BlinqCRISP /f /sprocs

This simply produces the result below with no indication as to what the error might be:

The compiler exited with code 1.  The command it executed was C:\Program Files\LINQ Preview\bin\csc.exe /r:"C:\Program Files\LINQ Preview\bin\System.Data.DLinq.dll" /r:"C:\Program Files\LINQ Preview\bin\System.Query.dll" /r:"C:\Program Files\LINQ Preview\bin\System.ComponentModel.Data.dll" /t:library /out:"C:\Documents and Settings\waros\Local Settings\Temp\CRISP.dll" "C:\Documents and Settings\waros\Local Settings\Temp\CRISP.cs".
No WebApp created

Compiler command (this shows detailed C# compiler errors which helps to isolate the problem):

"C:\Program Files\LINQ Preview\bin\csc.exe" /r:"C:\Program Files\LINQ Preview\bin\System.Data.DLinq.dll" /r:"C:\Program Files\LINQ Preview\bin\System.Query.dll" /r:"C:\Program Files\LINQ Preview\bin\System.ComponentModel.Data.dll" /t:library /out:"C:\Documents and Settings\waros\Local Settings\Temp\CRISP.dll" "C:\Documents and Settings\waros\Local Settings\Temp\CRISP.cs"

This shows (lots of) messages similar to the following:

c:\Documents and Settings\waros\Local Settings\Temp\CRISP.cs(13282,20): error CS0102: The type 'BlinqCrisp.PrDBAForeignKeyMaintenanceResult' already contains a definition for '_Name'
c:\Documents and Settings\waros\Local Settings\Temp\CRISP.cs(13280,20): (Location of symbol related to previous error)

Deleting the procedure and rerunning the BLINQ command solved the problem.

 

Thanks for reporting this, Warren.  We're looking into this and will make sure it's fixed in future releases.  You found one workaround- delete the sproc.  Another workaround is to delete the method and result type created by Blinq to represent the sproc in crisp.cs.  In your case the result type was PrDBAForeignKeyMaintenanceResult.