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.
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
Dear Kendo Experts,
I hope this message finds you well.
I am currently facing an issue with custom validation error messages in a Kendo Grid. I have created a sample Dojo link to demonstrate the problem:
https://dojo.telerik.com/IgOLaREr
I have a kendo grid with a custom editor (dropdownlist) for a column (Category).
In the provided Kendo Grid, I have two columns: "ProductName" and "Category". While "ProductName" has a default editor, "Category" has a custom editor (dropdown list).
I have defined custom validation error messages for both columns in the schema. However, the custom validation error message for the "Category" column does not appear when validation fails, unlike the "ProductName" column. Please refer the below screenshot.
Could you please assist me in resolving this issue? I would like the custom validation error message for the "Category" column to be displayed when validation fails, similar to the "ProductName" column.
Thank you very much for your time and assistance. I look forward to hearing from you soon.
Best regards,
Varun Shridhar.
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,
你好!
我想知道如何删除我不久前为了下载试用版而必须创建的 telerik 用户帐户。不幸的是,我找不到任何关于如何做到这一点的提示。
任何帮助表示赞赏。
提前致谢!
I'm currently fine-tuning a project that involves MySQL and Telerik, and I've hit a roadblock when it comes to understanding the nuances between CHAR and VARCHAR. Specifically, I'm interested in how these choices may impact UI development with Telerik controls. Can someone help me decode these intricacies?
Let's start by sharing a CodeIgniter model snippet and MySQL table structure:
class Customer_model extends CI_Model {
public function add_customer($customer_id, $customer_name, $email) {
$data = array(
'customer_id' => $customer_id,
'customer_name' => $customer_name,
'email' => $email
);
$this->db->insert('customers', $data);
return $this->db->insert_id();
}
}
CREATE TABLE customers (
id INT AUTO_INCREMENT PRIMARY KEY,
customer_id CHAR(8),
customer_name VARCHAR(50),
email VARCHAR(255)
);
Question 1: CHAR vs. VARCHAR in MySQL
I've opted for CHAR(8) for customer_id and VARCHAR(50) for customer_name. Could someone shed light on the primary distinctions between CHAR and VARCHAR in MySQL, particularly concerning storage efficiency and how these choices might influence Telerik controls used in UI development?
Question 2: Telerik and MySQL Integration
Considering Telerik controls in the UI development landscape, are there specific considerations when working with VARCHAR fields like customer_name or email in MySQL? How do these considerations align with best practices for Telerik UI components, and are there potential pitfalls to be mindful of during integration?
Question 3: Effective Data Handling using Telerik.
In the context of data transmission between MySQL and Telerik, as seen here, how does the decision between CHAR and VARCHAR affect the effectiveness of data retrieval or processing within Telerik controls? Are there any ideas or best practices for managing variable-length fields in Telerik UI components?
Question 4: The impact on Telerik Grids and Forms.
Finally, when developing Telerik Grids or Forms, how do the MySQL data types used effect the layout, performance, and validation? Are there any special obstacles or benefits to using CHAR or VARCHAR fields in MySQL when working with Telerik UI components?
Your expertise on these questions will be invaluable as I strive for a seamless integration of MySQL data and Telerik controls in my UI development. Thanks a bunch for sharing your insights!