Questions tagged [table-splitting]
32 questions
17
votes
7 answers
Entity Framework Table Splitting: not in the same type hierarchy / do not have a valid one to one foreign key relationship
I'm using Entity Framework 6 with a Code-First approach, and I want two entities to be put in the same table. What am I doing wrong?
[Table("Review")]
public class Review
{
public int Id { get; set; }
public PictureInfo PictureInfo { get;…
Andrew
- 817
- 2
- 10
- 21
5
votes
1 answer
Count of data from one column into multiple columns with MySQL?
I am having trouble understanding how to split and count different activities into separate columns. This is the beginning table:
+------------+---------+
| CustomerID |Activity |
+------------+---------+
| 1 | Click |
| 1 | View…
J Hsia
- 53
- 4
4
votes
1 answer
How to get COUNT(*) from one partition of a table in SQL Server 2012?
My table have 7 million records and I do split table in 14 part according to ID, each partition include 5 million record and size of partition is 40G. I want to run a query to get count in one partition but it scan all partitions and time of Query…
Masoomian
- 740
- 1
- 10
- 25
4
votes
1 answer
EF6 failing to build model for Table Split/Shared Primary Key + Base class?
The problem
I'm trying to share a large table (200+fields) around ~7 entities using table splitting as per my previous question.
EF6 requires navigation properties not just from the primary model to the child models, but between all the child models…
Brendan Hill
- 3,406
- 4
- 32
- 61
4
votes
2 answers
EF6 Table splitting vs shared primary key for multiple splits
I am upgrading a legacy database system into .NET + Entity Framework 6 (code-first POCO) + PostgreSQL. For ease of programming, I wish to split a large table (200+ fields) into multiple entities,…
Brendan Hill
- 3,406
- 4
- 32
- 61
3
votes
2 answers
split data frame with recurring column names
I have this big data containing a compilation of several data frames with common column names. To illustrate, it looks a little something like this:
df <- data_frame(A = c(runif(3), "A", runif(4), "A", runif(5)),
B = c(runif(3),…
mand3rd
- 383
- 1
- 12
3
votes
1 answer
Entity Framework table splitting - how to initialize lazy-loaded properties?
Using Entity Framework 6.0, I am attempting to implement table splitting to improve query performance on tables with columns that contain BLOB data. I have followed the recommendations in this tutorial and it does indeed work as described.
Here's a…
Tim Coulter
- 8,705
- 11
- 64
- 95
2
votes
1 answer
How to disable optional dependent entities
I have the following two entities refering to one table using split table option from EF Core - this very simplified version:
class Account
int Id
Settings Settings
class Settings
int AccountId (maps to Id)
string PropertyX
…
Dirk Boer
- 8,522
- 13
- 63
- 111
2
votes
1 answer
Can a Table Be Split Into EF Classes With a One-To-Many Relationship?
Database Structure
I've got a very denormalized SQL table with a structure like this:
CREATE TABLE logistix.shipments
(
shipment_id INT NOT NULL PRIMARY KEY,
destination_id NVARCHAR(15) NOT NULL PRIMARY KEY,
pallet_id INT NOT NULL…
JAF
- 385
- 1
- 2
- 12
2
votes
0 answers
Is it possible to block region's splitting in hbase coprocessor?
I have some processing(enrichment of trades) in my coprocesserService which modifies the existing data in place. It iterates over every row, modifies and puts it back to region. The table can be modified by only one client.
During the processing…
dpolaczanski
- 386
- 1
- 3
- 18
2
votes
1 answer
Table splitting - is it possible to split a table into two entirely independent entities?
I have a simple user table:
CREATE TABLE User
(
UserId int,
UserName nvarchar(35),
Password nvarchar(size),
);
I want to split this up into two entities in EF6. User and UserPassword. These represent two very different business needs, but happen…
Price Jones
- 1,948
- 1
- 24
- 40
1
vote
4 answers
split dataframe with recurring columnames
I have imported an excel sheet in R which is a compilation of several dataframes with identical columnnames. To illustrate it looks like this:
df <- tibble( empty = c(runif(3), NA, NA, NA, NA),
A = c(runif(3), NA, NA, NA, NA),…
user2165379
- 445
- 4
- 20
1
vote
2 answers
Splitting a column of a table in Latex
I want to create something like this:
Can someone explain how to do it?
Davide Goretti
- 21
- 2
1
vote
1 answer
Split table to multiple slides in PowerPoint file
I'm using GemBox.Presentation and I'm creating a large table in my PPTX file. Similar to this example, e.g.:
PresentationDocument presentation = new PresentationDocument();
Slide slide = presentation.Slides.AddNew(SlideLayoutType.Custom);
int…
hertzogth
- 236
- 1
- 2
- 19
1
vote
0 answers
How do you map multiple objects to a single table in EF Core using Table Splitting?
Before you mark this as a duplicate of This one know that I've used that.
I want to connect to a DB using EF core.
My desired process:
I receive information from a JSON post
deserialize it to a set of objects based on the structure of the…
leigero
- 3,233
- 12
- 42
- 63