Hi,

I know this product is retired since long ago.

But in our 10 years old legacy code, we have now requirement to migrate few tables in MySQL from SQL server. This old code is using Telerik.OpenAccess Nuget version 2016.2.822.1 and there is complex business logic written using it.

It is hard to change that bulk of code to use Entity Framework, so we thought to use My SQL connector with Telerik ORM as explained here https://docs.telerik.com/data-access/developers-guide/database-specifics/database-specifics-mysql-overview

I've everything setup as per the Article above. But when I run this code, it throws error which says Connection option 'datasource' is duplicated.

The connection string is perfectly fine and nothing duplicated in it: DataSource=127.0.0.1;port=3306;database=dbname;user=root;password=******

In fact, anything I change in connection string, it complains with same kind of error. For example Server=127.0.0.1;port=3306;database=dbname;user=root;password=******

It shows Connection option 'Server' is duplicated.

Kindly please help if you have used Telerik ORM with MySQL previously.

Hello,

Although Telerik is awesome I wish to delete my Telerik account, Telerik Forums account and all of the data associated with this account. Please help me out with this.

Thanking You,

With Regards,

Subhadeep Bhattacharyya.

Hi we're receiving this error regarding Kendo.Core.Export.dll however the DLL is present. Any ideas? There are similar issues here in the Community Forums however we have yet to discover a solution.

Line 18 in Program.cs:

builder.Services.AddControllersWithViews()

Complete exception message:

Application: w3wp.exe
CoreCLR Version: 8.0.424.16909
.NET Version: 8.0.4
Description: The process was terminated due to an unhandled exception.
Exception Info: Application '/LM/W3SVC/2/ROOT/appname' with physical root 'C:\webapplications\appname\06072024\' hit unexpected managed exception, exception code = '0xe0434352'. First 30KB characters of captured stdout and stderr logs:
Unhandled exception. System.IO.FileNotFoundException: Could not load file or assembly 'Kendo.Core.Export, Culture=neutral, PublicKeyToken=null'. The system cannot find the file specified.
File name: 'Kendo.Core.Export, Culture=neutral, PublicKeyToken=null'
   at System.Reflection.RuntimeAssembly.<InternalLoad>g____PInvoke|49_0(NativeAssemblyNameParts*, ObjectHandleOnStack, StackCrawlMarkHandle, Int32, ObjectHandleOnStack, ObjectHandleOnStack)
   at System.Reflection.RuntimeAssembly.InternalLoad(NativeAssemblyNameParts*, ObjectHandleOnStack, StackCrawlMarkHandle, Boolean , ObjectHandleOnStack, ObjectHandleOnStack)
   at System.Reflection.RuntimeAssembly.InternalLoad(AssemblyName, StackCrawlMark&, AssemblyLoadContext , RuntimeAssembly , Boolean )
   at System.Reflection.RuntimeAssembly.InternalLoad(String, StackCrawlMark&, AssemblyLoadContext )
   at System.Reflection.Assembly.Load(String)
   at Microsoft.AspNetCore.Mvc.ApplicationParts.ApplicationPartManager.<>c.<GetApplicationPartAssemblies>b__8_0(ApplicationPartAttribute name)
   at System.Linq.Enumerable.SelectArrayIterator`2.Fill(ReadOnlySpan`1, Span`1, Func`2)
   at System.Linq.Enumerable.SelectArrayIterator`2.ToArray()
   at System.Linq.Buffer`1..ctor(IEnumerable`1)
   at System.Linq.OrderedEnumerable`1.GetEnumerator()+MoveNext()
   at System.Linq.Enumerable.SelectManySingleSelectorIterator`2.MoveNext()
   at System.Linq.Enumerable.ConcatIterator`1.MoveNext()
   at Microsoft.AspNetCore.Mvc.ApplicationParts.ApplicationPartManager.PopulateDefaultParts(String)
   at Microsoft.Extensions.DependencyInjection.MvcCoreServiceCollectionExtensions.GetApplicationPartManager(IServiceCollection, IWebHostEnvironment)
   at Microsoft.Extensions.DependencyInjection.MvcCoreServiceCollectionExtensions.AddMvcCore(IServiceCollection)
   at Microsoft.Extensions.DependencyInjection.MvcServiceCollectionExtensions.AddControllersCore(IServiceCollection)
   at Microsoft.Extensions.DependencyInjection.MvcServiceCollectionExtensions.AddControllersWithViewsCore(IServiceCollection)
   at Microsoft.Extensions.DependencyInjection.MvcServiceCollectionExtensions.AddControllersWithViews(IServiceCollection)
   at Program.<Main>$(String[]) in C:\AppName\Program.cs:line 18

I am trying to maintain a pre-existing piece of software that uses Telerik Data Access for data access and also Telerik Kendo on the frontend. Several Kendo grids in the software represent tables in the database, except in order to be more user-friendly, instead of displaying foreign keys, they display the Display Names of the objects those foreign keys represent.

In order to fill the grid, then, the data call made by the UI might look something like this:

[root]/DataServices/[tenant]/odata/HouseModels?%24format=json&%24top=100&%24count=true&%24expand=DoorStyle(%24select%3DID%2CDisplayName)%2CWindowStyle(%24select%3DID%2CDisplayName)%2CDeckStyle(%24select%3DID%2CDisplayName)%2CFinishStyle(%24select%3DID%2CDisplayName)

This works fine in all ways except one: if a foreign key column is nullable and the user sorts or filters on that column, all rows that have a null value in that column will disappear. (Ironically, this even happens if the user filters specifically to show only null values! They will always see no results!)

I personally don't care whether null values are sorted before or after non-null values, but entire rows should never disappear entirely just from sorting (or in a way that makes zero sense for a particular filter).

[Note: The 'HouseModels' thing above is just an example. My data has nothing to do with houses, so yes, it does make sense to have nullable FKs.]

Using SQL Profiler, I believe I have determined the Data Access behaviour that is causing this problem. When the user tries to apply a sort or filter, the first call received by the database will look something like this if the user sorts the 'Door Style' column:

SELECT  TOP(100)
a.[ID] AS COL1,a.[FinishStyleID] AS COL2,a.[DoorStyleID] AS COL3,
a.[WindowStyleID] AS COL4,a.[DeckStyleID] AS COL5,
(CASE WHEN a.[DoorStyleID] IS NULL THEN NULL
    ELSE b.[DisplayName] END)
AS xj1
FROM [HouseModels] a
JOIN [User DoorStyles] AS b
ON (a.[DoorStyleID] = b.[ID])
/*permissions-related SQL omitted*/
ORDER BY xj1 DESC

From what I can tell, the results of this first call determine what rows will be visible in the grid, because the subsequent data calls are to fulfill all of the 'expand' requirements for all the IDs in the result of that first call.

As you can see, this means the problem is in the "JOIN" in the first call. Whether the user is filtering or sorting, that JOIN will always be on the column being sorted or filtered. Due to that being a "JOIN" instead of a "LEFT JOIN", all rows with a null value in that column are completely omitted from the results.

Is there any way that I can change this to be a LEFT JOIN? I don't know how to configure or override that part of what Data Access is doing.

[Note: At this time, we have to keep using Data Access. Completely replacing that is way beyond the scope of this small bug I am trying to fix.]

Yes, you can add watermarks to your PDF Files. Use the PDF Watermark application to recognize your PDFs as a logo, image, or text. The tool can watermark your PDF File at one time on every Page of the PDF file. The tool's Best feature is customized watermarks of your choice and some multiple-time increases of the opacity level from lighter to darker and darker to lighter. The tool permits enough flexibility in setting position to the top, left, right, center, and middle. The software is a user-friendly application that a non-technician can understand and operate without technical help. Download the tool today.

Hi everyone!.

Im trying to put a "NumericTextBox" inside s "ForItem", cause i need extract some validation that i have in another file. and call some method that returns me a math result But when i try it, my proyect fails.

someone have  worked with something similar?