Here is the command run with the results as you requested.
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\myName\Local Settings\Temp\Sideclicker.dll"
"C:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs"
Microsoft (R) Visual C# 2005 Compiler version 8.00.50916
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(62,27):
error CS0136: A local variable named 'result' cannot be declared in this scope
because it would give a different meaning to 'result', which is already
used in a 'parent or current' scope to denote something else
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(62,36):
error CS0029: Cannot implicitly convert type
'System.Data.DLinq.StoredProcedureResult' to 'int?'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(63,45):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'GetParameterValue'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(64,19):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'ReturnValue'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(69,27):
error CS0136: A local variable named 'result' cannot be declared in this scope
because it would give a different meaning to 'result', which is already
used in a 'parent or current' scope to denote something else
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(69,36):
error CS0029: Cannot implicitly convert type
'System.Data.DLinq.StoredProcedureResult' to 'int?'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(70,45):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'GetParameterValue'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(71,19):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'ReturnValue'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(76,27):
error CS0136: A local variable named 'result' cannot be declared in this scope
because it would give a different meaning to 'result', which is already
used in a 'parent or current' scope to denote something else
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(76,36):
error CS0029: Cannot implicitly convert type
'System.Data.DLinq.StoredProcedureResult' to 'int?'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(77,45):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'GetParameterValue'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(78,19):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'ReturnValue'
Thanks again for any help you can give. This program could be a real benefit for me if I can get sprocs working right.
Kxine, this looks like a bug in SqlMetal. It looks like it comes down to 3 or 4 distinct issues, each with a few instances. The "result" problem can probably be fixed by renaming the parent scope property called result. The others you can examine more
closely by opening c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs and seeing if the fix is obvious.
The best way to work around this would be to manually add the fixed sproc pieces to the code Blinq generates. Try this:
Run Blinq using the /sproc command.
Copy the generate SideClicker.cs into a file called SideClickerWithSprocs.cs
Run Blinq without using the /sproc command
Copy SideClickerWithSprocs.cs into SideClicker.cs
Fix the generated code
Blinq should now run if all the compiler errors are gone. I apologize for the issues in SqlMetal that are causing the bugs in sproc generation, and I hope they're relatively easy to fix so that you can make make progress with Blinq. Good luck...
Polita Paulus
This posting is provided "AS IS" with no warranties, and confers no rights.
Marked as answer by Kxine on Apr 20, 2007 04:45 PM
Kxine
Member
1 Points
3 Posts
/sprocs error
Apr 11, 2007 05:41 PM|LINK
When using the /sprocs command I get the following error:
C:\Program Files\Microsoft ASP.NET\Blinq>Blinq /t:C:\TestBlinqWithSC /database:Sideclicker /vDir:SCBlinq /f
WebApp created at C:\TestBlinqWithSC
C:\Program Files\Microsoft ASP.NET\Blinq>Blinq /t:C:\TestBlinqWithSC /database:Sideclicker /vDir:SCBlinq /f /sprocs
The compiler exited with code 1. The command it executed was C:\Program Files\L
INQ 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 File
s\LINQ Preview\bin\System.ComponentModel.Data.dll" /t:library /out:"C:\Documents
and Settings\jrobertson\Local Settings\Temp\Sideclicker.dll" "C:\Documents and
Settings\jrobertson\Local Settings\Temp\Sideclicker.cs".
No WebApp created
Bug? Problems with my sprocs?
Thanks for any help
phuff
Contributor
2700 Points
547 Posts
Microsoft
Re: /sprocs error
Apr 12, 2007 03:17 AM|LINK
This posting is provided "AS IS" with no warranties, and confers no rights.
Kxine
Member
1 Points
3 Posts
Re: /sprocs error
Apr 12, 2007 02:26 PM|LINK
Here is the command run with the results as you requested.
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\myName\Local Settings\Temp\Sideclicker.dll"
"C:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs"
Microsoft (R) Visual C# 2005 Compiler version 8.00.50916
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(62,27):
error CS0136: A local variable named 'result' cannot be declared in this scope
because it would give a different meaning to 'result', which is already
used in a 'parent or current' scope to denote something else
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(62,36):
error CS0029: Cannot implicitly convert type
'System.Data.DLinq.StoredProcedureResult' to 'int?'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(63,45):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'GetParameterValue'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(64,19):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'ReturnValue'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(69,27):
error CS0136: A local variable named 'result' cannot be declared in this scope
because it would give a different meaning to 'result', which is already
used in a 'parent or current' scope to denote something else
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(69,36):
error CS0029: Cannot implicitly convert type
'System.Data.DLinq.StoredProcedureResult' to 'int?'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(70,45):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'GetParameterValue'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(71,19):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'ReturnValue'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(76,27):
error CS0136: A local variable named 'result' cannot be declared in this scope
because it would give a different meaning to 'result', which is already
used in a 'parent or current' scope to denote something else
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(76,36):
error CS0029: Cannot implicitly convert type
'System.Data.DLinq.StoredProcedureResult' to 'int?'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(77,45):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'GetParameterValue'
c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs(78,19):
error CS0117: 'System.Nullable<int>' does not contain a definition for
'ReturnValue'
Thanks again for any help you can give. This program could be a real benefit for me if I can get sprocs working right.
phuff
Contributor
2700 Points
547 Posts
Microsoft
Re: /sprocs error
Apr 18, 2007 06:19 PM|LINK
Kxine, this looks like a bug in SqlMetal. It looks like it comes down to 3 or 4 distinct issues, each with a few instances. The "result" problem can probably be fixed by renaming the parent scope property called result. The others you can examine more closely by opening c:\Documents and Settings\myName\Local Settings\Temp\Sideclicker.cs and seeing if the fix is obvious.
The best way to work around this would be to manually add the fixed sproc pieces to the code Blinq generates. Try this:
Blinq should now run if all the compiler errors are gone. I apologize for the issues in SqlMetal that are causing the bugs in sproc generation, and I hope they're relatively easy to fix so that you can make make progress with Blinq. Good luck...
This posting is provided "AS IS" with no warranties, and confers no rights.
Kxine
Member
1 Points
3 Posts
Re: /sprocs error
Apr 20, 2007 04:43 PM|LINK
Thanks Polita. I appreciate the help.