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.
I am getting this error when hosting on our application. It does not appear to happen locally.
We are using the new .Net 8 autorender functionality and this seems to happen only in a virtual environment. I can give more context if needed.
I am using telerik version 2014.3.1024.45 with Asp.Net Webforms
I am using Telerik RadGrid. Columns are being sorted using string value. However if a particular column has integer values, it fails to sort properly. E.g. For the values 0, 1, 10, 2, 12, 3 It will sort as 0, 1, 10, 12, 2, 3
I tried setting DataType="System.Int32" for column but still it considers as string. This column has on the fly values so I can not sort at database also.
Would appreciate any suggestion here. Is there any way to do it ?
Thanks In advance
I am currently experiencing an I/O exception when trying to export the RadDocument to a byte array using the Telerik.Windows.Documents.FormatProviders.Pdf.PdfFormatProvider.
Here is a code snippet of how am I using the Provider:
PdfFormatProvider pdfProvider = new PdfFormatProvider();
_printReportByteArray = pdfProvider.Export(_printReportDocument);
using (var memoryStream = new MemoryStream(_printReportByteArray))
{
this.PrintReportViewer.DocumentSource = new PdfDocumentSource(memoryStream);
}
The exception occurs at
pdfProvider.Export(_printReportDocument)
It appears that the provider is trying to load the font file from the Windows directory, but for some reason this particular file is causing the exception randomly on certain machines (not on all machines). I would like to know if there is a way to resolve this issue. Like loading the font file into the memory instead of relying on the Windows directory.
Note: the font file does exist at the provided path location, and is not missing.
Here is the full exception message:
System.IO.IOException: I/O error occurred while opening the file "C:\WINDOWS\FONTS\MSYH.TTC". at MS.Internal.FontCache.FileMapping.OpenFile(String fileName) at MS.Internal.FontCache.FontSource.GetUnmanagedStream() at System.Windows.Media.GlyphTypeface.ComputeSubset(ICollection`1 glyphs) at Telerik.Windows.Documents.FormatProviders.Pdf.Fonts.GlyphMappings.ComputeSubset(PdfFontKey key, ICollection`1 glyphs) at Telerik.Windows.Documents.FormatProviders.Pdf.RadPdf.PdfFontFile2.CreateFileFontFile() at Telerik.Windows.Documents.FormatProviders.Pdf.RadPdf.PdfFontFile2.WriteContents(PdfWriter writer) at Telerik.Windows.Documents.FormatProviders.Pdf.RadPdf.PdfStream.WriteToCore(PdfWriter writer) at Telerik.Windows.Documents.FormatProviders.Pdf.RadPdf.PdfObject.WriteTo(PdfWriter writer) at Telerik.Windows.Documents.FormatProviders.Pdf.RadPdf.PdfWriter.WritePdfObject(PdfObject obj) at Telerik.Windows.Documents.FormatProviders.Pdf.PdfDocumentExporter.Export() at Telerik.Windows.Documents.FormatProviders.Pdf.PdfFormatProvider.Export(RadDocument document, Stream output) at Telerik.Windows.Documents.FormatProviders.DocumentFormatProviderBase.Export(RadDocument document) at Cairful.Desktop.Module.Care.NursingReports.NursingReports.Dialogs.PrintReportsDialogVM.PrintReportDocument() at Cairful.Desktop.Module.Care.NursingReports.NursingReports.Dialogs.PrintReportsDialog.PrintReportsDialog_OnLoaded(Object sender, RoutedEventArgs e) at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args) at System.Windows.UIElement.RaiseEvent(RoutedEventArgs e) at System.Windows.BroadcastEventHelper.BroadcastEvent(DependencyObject root, RoutedEvent routedEvent) at System.Windows.BroadcastEventHelper.BroadcastLoadedEvent(Object root) at MS.Internal.LoadedOrUnloadedOperation.DoWork() at System.Windows.Media.MediaContext.FireLoadedPendingCallbacks() at System.Windows.Media.MediaContext.FireInvokeOnRenderCallbacks() at System.Windows.Media.MediaContext.RenderMessageHandlerCore(Object resizedCompositionTarget) at System.Windows.Media.MediaContext.RenderMessageHandler(Object resizedCompositionTarget) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
2024-02-28T18:00:41.4616269Z Installed:
2024-02-28T18:00:41.4616442Z 88 package(s) to packages.config projects
2024-02-28T18:00:41.4938491Z ##[error]The nuget command failed with exit code(1) and error(Unable to find version '2023.3.1010' of package 'Telerik.UI.for.AspNet.Ajax.Net45'.
https://api.nuget.org/v3/index.json: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://api.nuget.org/v3/index.json'.
https://nuget.devexpress.com/redacted/api: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://nuget.devexpress.com/redacted/api'.
https://nuget.telerik.com/V3/index.json: Canceled
Errors in packages.config projects
Unable to find version '2023.3.1010' of package 'Telerik.UI.for.AspNet.Ajax.Net45'.
https://api.nuget.org/v3/index.json: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://api.nuget.org/v3/index.json'.
https://nuget.devexpress.com/redacted/api: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://nuget.devexpress.com/redacted/api'.
https://nuget.telerik.com/V3/index.json: Canceled
Unable to find version '2023.3.1010' of package 'Telerik.UI.for.AspNet.Ajax.Net45'.
https://api.nuget.org/v3/index.json: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://api.nuget.org/v3/index.json'.
https://nuget.devexpress.com/redacted/api: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://nuget.devexpress.com/redacted/api'.
https://nuget.telerik.com/V3/index.json: Canceled)
2024-02-28T18:00:41.4948266Z ##[error]Packages failed to restore
2024-02-28T18:00:41.4958660Z ##[section]Finishing: NuGetCommand
When I open the url, `https://nuget.telerik.com/V3/index.json` in a web browser and provide my creds, the returned json is there just fine
Hello there.
I'm presently working on a Node.js project that uses Telerik and MongoDB with Mongoose for database operations, however I'm having trouble quickly implementing CRUD (Create, Read, Update, Delete) actions. I'm hoping to receive some ideas and advice from the community to help us overcome these obstacles and enhance our database interactions.
Scenario Overview:
In our Telerik-based Node.js application, we use MongoDB as our database solution, with Mongoose as the MongoDB object modeling tool. Our application manages a variety of entities and data collections, and we must use CRUD operations to create, read, update, and remove data entries in MongoDB.
The code sample below demonstrates our current method to implementing CRUD operations using Mongoose and MongoDB in our Telerik Node.js application. Take a look, and let's go into the complexities of database interactions using Mongoose and MongoDB.
// Sample code demonstrating CRUD operations with Mongoose and MongoDB in Telerik
const mongoose = require('mongoose');
// Connect to MongoDB database
mongoose.connect('mongodb://localhost:27017/mydb', { useNewUrlParser: true, useUnifiedTopology: true });
const db = mongoose.connection;
// Define Mongoose schema and model
const userSchema = new mongoose.Schema({
name: String,
email: String,
age: Number
});
const User = mongoose.model('User', userSchema);
// CRUD operations
// Implement CRUD operations using Mongoose model methods
// ...
Key Points of Concern:
Model Schema Design: Creating effective Mongoose schemas to describe our data models and build relationships among distinct things in the MongoDB database. How can we optimize our schema design to maintain data consistency and integrity while allowing for complicated data structures?
Implementing CRUD operations (Create, Read, Update, and Delete) with Mongoose to interface with MongoDB collections. How can we simplify the implementation of CRUD procedures to ensure speedy and error-free database interactions?
Data validation and error handling: Putting in place measures to assure data integrity and prevent incorrect data from being put into the database. How can we apply data validation rules and gracefully manage mistakes during CRUD operations?
Performance optimization entails optimizing database queries and processes to increase performance and scalability, as described in the documentation. How can we use Mongoose query optimization and MongoDB indexing algorithms to improve the speed of CRUD operations in our Node.js application?
Let's work together to overcome these CRUD operations difficulties!
Thanks