Demo installation problems, UI for ASP.NET MVC

[Brad]

I'm brand new to ASP.net core MVC and Telerik, and my first post in the forums is a plea for help getting a demo up and running in VS 2015.   

I downloaded and installed a trial of Telerik's UI for ASP.NET MVC, and opened the Kendo.Mvc.Examples solution.

Immediately, I am now faced with two problems which, despite hours of searching here and elsewhere, cannot be solved without help from the forums.  This doesn't give me much confidence, and has led to hours of frustration.

Problem 1:

The compiler reports that Microsoft.Web.Infrastructure version=1.0.0.0 could not be found.

    Problem 2:

The Sample.mdf database requires Sql Server Express 2012 Localdb.   I have SQL Server 2016 installed.  I even installed SQL Server 2012 express, and it still doesn't let me use the sample.mdf database.

[Vessy]

Hi Brad,

If any package is not found on your local machine you could use nuget package restore to retrieve it. Here is a link to Microsoft.Web.Infrastructure: https://www.nuget.org/packages/microsoft.web.infrastructure/

As for LocalDB  - it is required for running the offline demos sample application. All recent versions (2012, 2014, 2016) should do. You can find further information about SQL Server 2016 Express LocalDB on MSDN: https://msdn.microsoft.com/en-us/library/hh510202.aspx

Please make sure to follow the steps described below to run the sample application, coming with your installation package:
http://docs.telerik.com/kendo-ui/aspnet-mvc/introduction#run-the-sample-application

Let me know, if you need further assistance.

Regards,
Vessy
Telerik

[Brad]

I suggest that you try this yourself, and you'll discover that the demo is broken.  I submitted two support tickets in less the 48 hours just to get the demo to run.

I figured out how to upgrade the supplied database (WHY isn't it already upgraded?!), and I can successfully see the table with the Server Explorer.   I can build and run.  BUT when clicking on the basic grid example I get an exception error:

System.Data.EntityException was unhandled by user code
  HResult=-2146233087
  Message=The underlying provider failed on Open.
  Source=System.Data.Entity
  StackTrace:
       at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
       at System.Data.EntityClient.EntityConnection.Open()
       at System.Data.Objects.ObjectContext.EnsureConnection()
       at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
       at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
       at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
       at System.Data.Objects.ELinq.ObjectQueryProvider.<>c__11`1.<GetElementFunction>b__11_3(IEnumerable`1 sequence)
       at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
       at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
       at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression)
       at Kendo.Mvc.Extensions.QueryableExtensions.Count(IQueryable source)
       at Kendo.Mvc.Extensions.QueryableExtensions.CreateDataSourceResult[TModel,TResult](IQueryable queryable, DataSourceRequest request, ModelStateDictionary modelState, Func`2 selector)
       at Kendo.Mvc.Extensions.QueryableExtensions.ToDataSourceResult(IQueryable queryable, DataSourceRequest request, ModelStateDictionary modelState)
       at Kendo.Mvc.Extensions.QueryableExtensions.ToDataSourceResult(IQueryable enumerable, DataSourceRequest request)
       at Kendo.Mvc.Extensions.QueryableExtensions.ToDataSourceResult(IEnumerable enumerable, DataSourceRequest request)
       at Kendo.Mvc.Examples.Controllers.GridController.Customers_Read(DataSourceRequest request) in C:\Program Files (x86)\Telerik\UI for ASP.NET MVC Q2 2016\wrappers\aspnetmvc\Examples\VS2013\Kendo.Mvc.Examples\Controllers\Grid\IndexController.cs:line 45
       at lambda_method(Closure , 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.Async.AsyncControllerActionInvoker.ActionInvocation.InvokeSynchronousActionMethod()
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
       at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
       at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
       at System.Web.Mvc.Async.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
  InnerException:
       Class=20
       ErrorCode=-2146232060
       HResult=-2146232060
       LineNumber=0
       Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot create an automatic instance. See the Windows Application event log for error details.
)
       Number=-1983577832
       Server=""
       Source=.Net SqlClient Data Provider
       State=0
       StackTrace:
            at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
            at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
            at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
            at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
            at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
            at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
            at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
            at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
            at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
            at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
            at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
            at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
            at System.Data.SqlClient.SqlConnection.Open()
            at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
       InnerException:

[Vessy]

Hi Brad,

Please excuse me for the lapse - we managed to replicate the missing package issue with the latest installation of the controls and are currently examining the cause for it. Meanwhile you can tun the VS2012 project, where the problem does not persist.

As for the shown in your latest reply error - can you try removing the integration security declaration from the connection string of your data base and see how it goes?

integrated security=True;

Regards,
Vessy
Telerik

[David]

The problem is not fixed in VS 2015 . I had to run VS 2012 example.

Please fix it

[Vessy]

Hi David,

We examined this problem thoroughly but, unfortunately, it turn out that this is a dependency problem that cannot be controlled by us, not by the configurations of the shipped sample project. The problem is sporadic and does not occurs in all machines we tested. After a further investigation of the problem we found that such a problem is commonly spread and the only way to force Visual Studio to resolve this dependency properly is to manually reinstall the Microsoft.Web.Infrastructure package.

You can review the following Stack Overflow thread, where the same problem and the solution for it have been discussed in details:
http://stackoverflow.com/questions/13149851/could-not-load-file-or-assembly-microsoft-web-infrastructure


Regards,
Vessy
Telerik by Progress

[Antony]

If the other replies don't fix things for you, perhaps this will help. I eventually thought to look for  Microsoft.Web.Infrastructure.dll in the bin folder of another VS projects on my computer. Fortunately it was there, so I copied it to the bin folder of the Telerik examples folder, which for my installation is C:\Program Files (x86)\Telerik\UI for ASP.NET MVC R1 2017\wrappers\aspnetmvc\Examples\VS2015\Kendo.Mvc.Examples\bin.

I had another issue getting LocalDB working. It was complicated, and involved use of the utility sqllocaldb.exe which is in C:\Program Files\Microsoft SQL Server\130\Tools\Binn>. I had to run the command to start LocalDB (sqllocaldb.exe s), and then in the connection string in web.config set the data source as follows: data source=(LocalDB)\MSSQLLocalDB

Finally, because I'm in Australia, when I tried the grid editing examples I had problems with dates. So I had to setup globalization for en-AU, which meant adding some lines to the Views/Shared/_Layout.cshtml file:

    <script src="@Url.Content("~/bundles/demo")"></script>  // this was there already - I added the next line
    <script src="@Url.Content("~/Scripts/cultures/kendo.culture.en-AU.min.js")"></script> 

and also, down at the bottom, just before the </body> closing tag

    <script>
         kendo.culture("en-AU");
    </script>

Best wishes!

Anthony

[Vessy]

Hi Anthony,

Thanks a lot for sharing your solution with our community and explaining it in such details. I hope it will help the other facing these issues.

Regards,
Vessy
Telerik by Progress

[Laura]

Thank you.  Your first paragraph worked perfectly and my demos are now working.

[May]

Hi,

I just downloaded the Demo and I'm using VS 2017.   The article says there should be sample applications in this folder:C:\Program Files (x86)\Progress\Telerik UI for ASP.NET MVC R2 2018\wrappers\aspnetmvc

but there is not.   I can do without the app but I really need the Sample database, specifically the Task table.  

Article needs to be updated:

https://docs.telerik.com/aspnet-mvc/introduction#run-the-sample-application

[Dimitar]

Hi May,

I have provided an answer in your support thread on the same topic. I would suggest to continue our communication there in order to prevent thread duplication.

Regards,
Dimitar
Progress Telerik