Bug while executing 'install-sqlservercache' command about session

[kichalla]

@hishamco ...follow the steps below and see if you still see the issue:

• Run dnu commands install Microsoft.Framework.Caching.SqlServer.SqlConfig to install the 'global' command called sqlservercache.
• Run sqlservercache <connectionstring-to-database> <schema-name> <table-name> to set up the table and indexes.
• Register this cache in DI. Example:

services.AddSqlServerCache(o =>
{
    o.ConnectionString = "Server=localhost;Database=SessionSampleDb;Trusted_Connection=True;";
    o.SchemaName = "dbo";
    o.TableName = "SessionSample";
});

[muratg]

@hishamco Closing this one. If @kichalla's instructions do not work, feel free to re-open :)

[hishamco]

Thanks @kichalla I'd like to inform you that the first step produce unable to locate the package Microsoft.Framework.Caching.SqlServer.SqlConfig

[hishamco]

@kichalla any idea about the error

[kichalla]

My bad, the package name is Microsoft.Framework.Caching.SqlConfig (notice that there is no SqlServer in it)

[hishamco]

I got ArgumentNullException paramter path1, please reopen the issue until it got fix

[kichalla]

@hishamco can you show the entire command that you are trying?

[hishamco]

Here is the command dnu commands install Microsoft.Framework.Caching.SqlConfig as you told me before

[muratg]

Activating for further investigation

[kichalla]

@hishamco I am unable to repro the issue that you are seeing

My DNU version is Microsoft .NET Development Utility CLR-x86-1.0.0-beta6-12232

Feeds used:
https://www.myget.org/F/aspnetvnext/api/v2/
https://www.nuget.org/api/v2/

[kichalla]

Also to isolate the issue, can you verify if you are able install another package having a global command..example:
dnu commands install Microsoft.Framework.SecretManager

[hishamco]

Finally the command executed successfully after upgrade dnvm to the version that you mentioned before, but still i'm facing an issue while executing sqlservercache command, I passed the connectionString, schema and table like what you mentioned before, but unrecognized argument error occurs in ConnectionString

[kichalla]

try this sqlservercache create <connectionstring-to-database> <schema-name> <table-name>

[hishamco]

I executed this sqlservercache create "server=.;database=myDB;integrated security=true" dbo Sessions, again error occurs "Format of initialization string does not conform to specification starting at index 23"

[kichalla]

I cannot repro your issue using the above command against my SQL Server 2012 server. Not sure if its specific to your sql server version, but this seems like an error with connection string: http://stackoverflow.com/questions/8243008/format-of-the-initialization-string-does-not-conform-to-specification-starting-a

[hishamco]

Thanks @kichalla it works fine when i used Trusted_Connection instead of Integrated Security, but when I run the sample there's no entries show up in the table

[kichalla]

Thanks @hishamco ...the instructions in the sample were incorrect...can you try with the updated instructions now: https://github.com/aspnet/Session/blob/dev/samples/SessionSample/Startup.cs#L23-L44

[hishamco]

Still the table is not updated anymore!!

[kichalla]

@hishamco Can you share your code?

[hishamco]

Finally .. it works as expected.
Thanks for your collaboration 😄