This is a migrated thread and some comments may be shown as answers.

Flatten object to table

0 Answers 63 Views
Development (API, general questions)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Thomas
Top achievements
Rank 1
Thomas asked on 21 Jan 2017, 01:06 PM

Hello, 

I have just begun working with the Telerik Open Data Access framework on top of an SQLite database. So far I am very impressed, and although there is some work involved in setting up the mapping and context, it is still fairly simple and straightforward compared to doing it by hand, so to speak. 

However, I have a question regarding mapping, specifically, if it is possible to flatten a class hierarchy before mapping it to a table. E.g. something like this:

01.public class SomeClass
02.{
03.        public int Id { get; set; }
04.        public string Number { get; set; }
05.        public string Name { get; set; }
06.        public Information Information { get; set; }  
07.}
08.
09.public class Information
10.{
11.        public bool Active { get; set; }
12.        public DateTime Created { get; set; }
13.        public string UpdatedBy { get; set; }
14.}

 

Should result in this table definition: 

01.create table SomeClass
02.(
03.    Id        int,
04.    Number    varchar(20),
05.    Name             varchar(255),
06.    Active    bit,
07.    Created   datetime,
08.    UpdatedBy varchar(255)
09.)

 

Is this possible?

 

 

 

Tags
Development (API, general questions)
Asked by
Thomas
Top achievements
Rank 1
Share this question
or