Questions tagged [telerik-open-access]

Telerik's object-relational mapper is a powerful framework for mapping the objects in your object-oriented domain model to your relational database tables, views, and/or stored procedures. This mapping is done within Visual Studio and is independent from source code and database - it is a virtual layer, which can be used from within the programming language to access and manipulate data.

Telerik's object-relational mapper is a powerful framework for mapping the objects in your object-oriented domain model to your relational database tables, views, and/or stored procedures. This mapping is done within Visual Studio and is independent from source code and database - it is a virtual layer, which can be used from within the programming language to access and manipulate data.

138 questions
0
votes
1 answer

Why must I include the Telerik ORM assembly in my MVC project when I have already included the Data layer?

I'm trying to get a simple example of Telerik ORM running on my site. I have a DAL which is a separate Visual Studio project. I also have an MVC5 application. Both projects are tied to a single solution. Pretty standard setup. In my DAL project, I…
Chace Fields
  • 857
  • 2
  • 10
  • 20
0
votes
1 answer

What is an example of an ORM query that causes SQL Injections and one that does not?

This answer describes how an ORM doesn't protect me from SQL injections, however I'm not entirely clear on how I would "do things wrong" vs "doing things right". Can someone provide an example in EntityFramework, or Telerik OpenAccess on how SQL…
0
votes
1 answer

Telerik Open Access error on string with 8000 characters

I'm trying to save 8,000 characters to a SQL Server Express database table, and this may be smaller or larger in the future, and I'm getting an exception saying that the data will be truncated. I've already set the column to varchar(max) and don't…
makerofthings7
  • 60,103
  • 53
  • 215
  • 448
0
votes
2 answers

Step by step application with partial views

So I have an application broken down into sections. These sections I put in there own partial views(keep in mind I can do it what ever way is best just though partial view might be that way for content management). I have a main view that contains…
NitroFrost
  • 133
  • 4
  • 20
0
votes
1 answer

Stored procedure validation best approach

Alright so I have a user table that I would like to check against. This user table has a username, email, and accountnumber. Would I would like to do is check if anyone of those has been taken and if it has return if it has been taken. I was…
NitroFrost
  • 133
  • 4
  • 20
0
votes
1 answer

sub classes can not have identity columns in inheritance mapping

I am designing a database using both ORM tools from Telerik ORM and Devexpress ORM data model wizard. I have two classes an employee and person class. The employee class inherits from person class which is the base class. Both ORMs insist the person…
0
votes
1 answer

OpenAccess ORM - WithCascadeDelete Not Available

I am using ORM version 2013.2.702.1 and ASP.NET MVC 4.5. I am trying to use WithCascadeDelete like the documentation: Cascade Delete on Class Level, but the method is not available: using FluentModel.Entity; using Telerik.OpenAccess.Metadata; using…
Michel Andrade
  • 4,056
  • 5
  • 27
  • 28
0
votes
2 answers

Clean data from database

I using ORM telerik open access in my project. I can use it to create and add data to my database. Now i want to clean all data from my database. I can do it by delete data from each table but it will take long code. I have google how to clean it…
Faisal Silitonga
  • 423
  • 1
  • 7
  • 14
0
votes
1 answer

Get data from mysql server and upload it into Sql server using Telerik openAcces ORM

I have this scenario: I am using Telerik OpenAccess ORM. I have a MySql database with the following structure: Products: ID, VendorID, [Product Name], MeasureID, [Base Price] Vendors: ID, [Vendor Name] Measures: ID,…
Mario Stoilov
  • 3,411
  • 5
  • 31
  • 51
0
votes
1 answer

Generate Enums from Tables using Telerik OpenAccess

Reading the Telerik OpenAccess documentation, I see that I can set the data type of a Domain Class Property to an enumeration I have explicitly coded. Instead of coding them, can I use OpenAccess to generate (and maintain) enumeration types from my…
Mat
  • 470
  • 7
  • 12
0
votes
1 answer

Telerik OpenAccess GUID is blanked off

I am trying to add a relatively simple entity via Telerik.OpenAccess. One property of this entity is a GUID set via c#'s GUID.NewGuid(). The property is set fine right before the call to SaveChanges() but then looking in SQL Profiler the value is…
chris stevens
  • 316
  • 4
  • 14
0
votes
1 answer

Unable to disting the record in Link Expression

I have two tables: TblAppointmentTypes and TblEmployeeInfo. There is many to many relation between these two tables with a joined table that is TblEmployeeServices. There are two records in TblAppointmentTypes and four records in TblEmployeeInfo.…
Waqas Ahmed
  • 48
  • 2
  • 12
0
votes
2 answers

At what point does an IList cause a query to execute in an ORM?

I am using telerik's OpenAccess ORM and I am making some changes to the generated code. For an entity that has a navigation property (a key to another table), these are generated as ILists like the following: private IList _SystemUsers =…
Justin
  • 6,373
  • 9
  • 46
  • 72
0
votes
1 answer

Telerik Openaccess ORM Update Object and Automapper

I am trying to update an object using telerik openaccess orm and automapper, it works for adding the object to scope but not update. I saw on their site someone having same issue, but the answer didn't really help me. here is my code which doesn't…
Zaki
  • 5,540
  • 7
  • 54
  • 91
0
votes
1 answer

Cannot find resource StAccountsDomainModel.rlinq embedded in assembly. Telerik OpenAccess

We have application hosted on azure cloud service platform using azure database. We have TFS hosted build controller which build application and deploy it on azure platform. Application working fine on local but we are getting following error when…
SOF User
  • 7,590
  • 22
  • 75
  • 121