Designer - Dragging SProc doesn't work

Im trying out LightSpeed for the first time but can't drag a stored proc to the designer surface successfully.  I get the following error:

Exception while processing Server Explorer drag: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: The provided string argument [name] cannot be empty
   at Mindscape.LightSpeed.Generator.Model.Invariant.ArgumentNotEmpty(String argument, String argumentName)
   at Mindscape.LightSpeed.Generator.Model.Field..ctor(String name, ModelDataType dataType, Boolean allowNulls)
   at Mindscape.LightSpeed.Generator.Extraction.SqlServerExtractorBase.ExtractSelectProcedure(SqlDataReader reader, ProcedureName procedureName)
   at Mindscape.LightSpeed.Generator.Extraction.SqlServerExtractorBase.ExtractProcedure(SqlDataReader reader, ProcedureName procedureName)
   at Mindscape.LightSpeed.Generator.Extraction.SqlServerExtractorBase.<ExtractProcedures>d__b.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at Mindscape.LightSpeed.Generator.Extraction.Provider`1.ExtractProcedures(IEnumerable`1 procedureNames)
   at Mindscape.LightSpeed.Generator.Integration.ProcedureBuilder.AddProceduresToModel(Model model, ILightSpeedDataSource connection, IEnumerable`1 procedureNames, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.LightSpeedModelDiagram.<>c__DisplayClass4.<OnDragDrop>b__3(DragObject dragObject, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.ServerExplorer.IfIsServerExplorerDrag(DragEventArgs e, DragAction action)

 I am using the current nightly build (Nightly Build for 17 Jul 2009 - LightSpeedExpress-20090717.msi).  And have tried uninstalling/reinstalling twice.

On a Sql Server 2005 database.

Hmm, sounds like one of the columns returned by the sproc has no name, which seems a bit strange.  Could you send us the stored procedure definition please?  Thanks!

I checked and there was a an unamed column.  Setting the name fixed this issue.

Now I'm getting:

 System.InvalidOperationException was unhandled by user code
  Message="The ConnectionString property has not been initialized."
  Source="System.Data"
  StackTrace:
       at System.Data.SqlClient.SqlConnection.PermissionDemand()
       at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Mindscape.LightSpeed.UnitOfWork.()
       at Mindscape.LightSpeed.UnitOfWork.PrepareCommand(IDbCommand command)
       at ...ctor(IUnitOfWork , ProcedureQuery )
       at ..
(IUnitOfWork , ProcedureQuery )
       at ..(TypeModel , ProcedureQuery , IList )
       at ..(UnitOfWork , TypeModel , ProcedureQuery , IList )
       at ..(TypeModel , ProcedureQuery , IList )
       at ..(ProcedureQuery , IList )
       at Mindscape.LightSpeed.UnitOfWork.Find[TEntity](ProcedureQuery query)
       at LightSpeed_CacheTest.Core.Data.SearchDbUnitOfWork.AppGetTopSearchItem(String test) in D:\SOURCE\LightSpeed_CacheTest\LightSpeed_CacheTest\Core\Data\SearchDb.cs:line 64
       at LightSpeed_CacheTest.Controllers.HomeController.Index(String input) in D:\SOURCE\LightSpeed_CacheTest\LightSpeed_CacheTest\Controllers\HomeController.cs:line 29
       at lambda_method(ExecutionScope , ControllerBase , Object[] )
       at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
       at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClassa.<InvokeActionMethodWithFilters>b__7()
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
  InnerException:

I suspect the configuration is wrong.  Here is what I have:

 <LightSpeed>
  <add name="default"
  dataProvider="SqlServer2008"
   connectionStringName="SearchConnString"
   identityMethod="KeyTable"/>
 </LightSpeed>

I do also have the configuration section and connection string.

bump

Oops, sorry for the delay in replying -- there seems to be an issue with the forums notifying us of new posts at the moment.

Your configuration file should contain something like this:

<configuration>

  <configSections>
    <section name="lightSpeedContexts"
          type="Mindscape.LightSpeed.Configuration.LightSpeedConfigurationSection, Mindscape.LightSpeed" />
</configSections>

<lightSpeedContexts>
  <add name="default"
   dataProvider="SqlServer2008"
   connectionStringName="SearchConnString"
   identityMethod="KeyTable"/>
</lightSpeedContexts>

Note that the configuration section is named lightSpeedContexts, not LightSpeed, and that you need an entry in the configSections section.  See Help Topics > LightSpeed > Configuration in the help file for an example configuration file.

If this doesn't fix it, could you post your config file (you can attach a file using the Options tab) and we will take a look at it.

That did it.  Thanks!

Do you have a documentation page with example configurations for different db types?

Sorry for all these questions but I keep getting errors.  I am now trying to replace some of my L2SQL code and I was able to drag one proc over just fine to the model designer.  But the second gave me this error:

Exception while processing Server Explorer drag: System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value 'A' to data type int.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Mindscape.LightSpeed.Generator.Extraction.SqlServerExtractorBase.<ExtractProcedures>d__b.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at Mindscape.LightSpeed.Generator.Extraction.Provider`1.ExtractProcedures(IEnumerable`1 procedureNames)
   at Mindscape.LightSpeed.Generator.Integration.ProcedureBuilder.AddProceduresToModel(Model model, ILightSpeedDataSource connection, IEnumerable`1 procedureNames, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.LightSpeedModelDiagram.<>c__DisplayClass4.<OnDragDrop>b__3(DragObject dragObject, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.ServerExplorer.IfIsServerExplorerDrag(DragEventArgs e, DragAction action)

We don't have specific sample configurations for different database types, because the configuration options are database-type-independent.  The only thing that would normally be database-dependent is the connection string.  If there's a particular configuration option that you think we're not illustrating clearly enough, or whose interaction with the database type you feel is unclear, please do let us know and we'll try to improve the docs!

I think this is occurring because we need to call the sproc to determine the kind of data it returns, which means we need to send it dummy data, and it looks like we may be sending the wrong kind of dummy data.  Could you provide us with the sproc definition, and the CREATE TABLE statements for any tables referenced by the sproc, so we can reproduce and track this down?  Thanks!