Styjun

Is it possible to have a character with proficiency in all martial weapons without proficiency in Medium armor?

Bin Packing with Relational Penalization

Movie with Zoltar in a trailer park named Paradise and a boy playing a video game then being recruited by aliens to fight in space

How can I deal with extreme temperatures in a hotel room?

Why was Mal so quick to drop Bester in favour of Kaylee?

Just graduated with a master’s degree, but I internalised nothing

Adjective for 'made of pus' or 'corrupted by pus' or something of something of pus

Are the requirements of a Horn of Valhalla cumulative?

"Vector quantity" --More than two dimensions?

Comment traduire « That screams X »

What's the safest way to inform a new user of their password on an invite-only website?

Find the radius of the hoop.

What exactly did Ant-Man see that made him say that their plan worked?

How did they film the Invisible Man being invisible, in 1933?

How to describe POV characters?

The warming up game

What will happen if I checked in for another room in the same hotel, but not for the booked one?

Losing queen and then winning the game

What verb for taking advantage fits in "I don't want to ________ on the friendship"?

Using “ser” without "un/una"?

13th chords on guitar

Can I travel from Germany to England alone as an unaccompanied minor?

How did Lefschetz do mathematics without hands?

How Do I Know When I am in Private Mode?

Need help creating new father entites and re-asigning child ones efficiently

How to create a new object instance from a TypeMax or Default?Saving my own created entites while updating in EDMXIn EF, is it efficient to delete a parent row by deleting the child rows referencing it first through the child row clones?Excel row insert with C#Best performance for find objects in entities and load entities, Foreach or where with LinQ ON C#?Get related entites of child items using Linq?error creating datatable from combined csv fileNeed help creating Creating Controller to Delete item from databaseHow to get id of new created child?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I create a Module from a CSV file, with a default Submodule , each Submodule contains segments (each row from the CSV) , now i need to SPLIT the segments into many submodules. When I created the project i created 1 default submodule with all the segments as childs to it .
Now for the code:

public Modules splitModule(int id, string type, int amount){
 var ModuleSplit = _context.Modules.Include(x=>x.SourceLang).Where(x=>x.Id == id).FirstOrDefault();
 var DefaultSubM = _context.Submodules.Include(x=>x.Segments).Where(x=>x.ModuleId == ModuleSplit.Id).FirstOrDefault();
 List<Submodules> listToAdd = new List<Submodules>();
 if(type == "linguists")
 //linguists = rows / linguists , rounded 
 var rowAmount = DefaultSubM.Segments.Count();
 int chunkSize = rowAmount / amount ;

 for(int i=0 ; i< amount-1 ; i++)
 Submodules newSub = new Submodules();
 newSub.Status = Abr.Active;
 newSub.Token = Guid.NewGuid().ToString();
 listToAdd.Add(newSub);
 

 _context.Submodules.AddRange(listToAdd);
 _context.SaveChanges();

 var skipAm = rowAmount;
 if(rowAmount % amount != 0)
 skipAm++;
 

 foreach(var a in listToAdd)
 var subL = DefaultSubM.Segments.Take(rowAmount).Skip(skipAm);
 foreach(var b in subL)
 a.Segments.Add(b);
 DefaultSubM.Segments.Remove(b);
 
 
 _context.SaveChanges();
 

I would need to take ChuckSize amount of segments from default Submodule to each new one. Is there a correct way to do it? , from what i know (little) , i would need to first add them to the context , save to get the Ids. then Take all but the first ChunkSize from the default one and add them to the second , then repeat for each one recursively.
Feel its a lot of code , and mess for this. Maybe i'm missing some magic way with linq or a method.

EDIT: Came up with this solution , but feels dirty and waaay more complex than it feels that should be...

EDIT2: Read somewhere i need to use Child.Parent = newParent Object.

c# entity-framework asp.net-core entity

share|improve this question

edited Mar 25 at 19:52

Rodrigo Chapeta

asked Mar 25 at 13:57

Rodrigo ChapetaRodrigo Chapeta

1444 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  For CSV then Microsoft.VisualBasic.FileIO have the TextFieldParser that lift up part of the logic. But I still think that you need to define and code a lot with your example
  
  – Thomas Koelle
  Mar 25 at 14:36
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi, for CSV , i have already added them to the Segments table, i used CSVHelper. Its just the part of Re assignin from One Submodule that contains ALL the segments to multiple submodules that each contain part of them. In SQL would be just updating the SubmoduleId of each segment to each new submodule Id . but wanted to see the entity framework solution.
  
  – Rodrigo Chapeta
  Mar 25 at 14:43
  

  
  
  
  

add a comment | 

1

I create a Module from a CSV file, with a default Submodule , each Submodule contains segments (each row from the CSV) , now i need to SPLIT the segments into many submodules. When I created the project i created 1 default submodule with all the segments as childs to it .
Now for the code:

public Modules splitModule(int id, string type, int amount){
 var ModuleSplit = _context.Modules.Include(x=>x.SourceLang).Where(x=>x.Id == id).FirstOrDefault();
 var DefaultSubM = _context.Submodules.Include(x=>x.Segments).Where(x=>x.ModuleId == ModuleSplit.Id).FirstOrDefault();
 List<Submodules> listToAdd = new List<Submodules>();
 if(type == "linguists")
 //linguists = rows / linguists , rounded 
 var rowAmount = DefaultSubM.Segments.Count();
 int chunkSize = rowAmount / amount ;

 for(int i=0 ; i< amount-1 ; i++)
 Submodules newSub = new Submodules();
 newSub.Status = Abr.Active;
 newSub.Token = Guid.NewGuid().ToString();
 listToAdd.Add(newSub);
 

 _context.Submodules.AddRange(listToAdd);
 _context.SaveChanges();

 var skipAm = rowAmount;
 if(rowAmount % amount != 0)
 skipAm++;
 

 foreach(var a in listToAdd)
 var subL = DefaultSubM.Segments.Take(rowAmount).Skip(skipAm);
 foreach(var b in subL)
 a.Segments.Add(b);
 DefaultSubM.Segments.Remove(b);
 
 
 _context.SaveChanges();
 

I would need to take ChuckSize amount of segments from default Submodule to each new one. Is there a correct way to do it? , from what i know (little) , i would need to first add them to the context , save to get the Ids. then Take all but the first ChunkSize from the default one and add them to the second , then repeat for each one recursively.
Feel its a lot of code , and mess for this. Maybe i'm missing some magic way with linq or a method.

EDIT: Came up with this solution , but feels dirty and waaay more complex than it feels that should be...

EDIT2: Read somewhere i need to use Child.Parent = newParent Object.

c# entity-framework asp.net-core entity

share|improve this question

edited Mar 25 at 19:52

Rodrigo Chapeta

asked Mar 25 at 13:57

Rodrigo ChapetaRodrigo Chapeta

1444 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  For CSV then Microsoft.VisualBasic.FileIO have the TextFieldParser that lift up part of the logic. But I still think that you need to define and code a lot with your example
  
  – Thomas Koelle
  Mar 25 at 14:36
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi, for CSV , i have already added them to the Segments table, i used CSVHelper. Its just the part of Re assignin from One Submodule that contains ALL the segments to multiple submodules that each contain part of them. In SQL would be just updating the SubmoduleId of each segment to each new submodule Id . but wanted to see the entity framework solution.
  
  – Rodrigo Chapeta
  Mar 25 at 14:43
  

  
  
  
  

add a comment | 

I create a Module from a CSV file, with a default Submodule , each Submodule contains segments (each row from the CSV) , now i need to SPLIT the segments into many submodules. When I created the project i created 1 default submodule with all the segments as childs to it .
Now for the code:

public Modules splitModule(int id, string type, int amount){
 var ModuleSplit = _context.Modules.Include(x=>x.SourceLang).Where(x=>x.Id == id).FirstOrDefault();
 var DefaultSubM = _context.Submodules.Include(x=>x.Segments).Where(x=>x.ModuleId == ModuleSplit.Id).FirstOrDefault();
 List<Submodules> listToAdd = new List<Submodules>();
 if(type == "linguists")
 //linguists = rows / linguists , rounded 
 var rowAmount = DefaultSubM.Segments.Count();
 int chunkSize = rowAmount / amount ;

 for(int i=0 ; i< amount-1 ; i++)
 Submodules newSub = new Submodules();
 newSub.Status = Abr.Active;
 newSub.Token = Guid.NewGuid().ToString();
 listToAdd.Add(newSub);
 

 _context.Submodules.AddRange(listToAdd);
 _context.SaveChanges();

 var skipAm = rowAmount;
 if(rowAmount % amount != 0)
 skipAm++;
 

 foreach(var a in listToAdd)
 var subL = DefaultSubM.Segments.Take(rowAmount).Skip(skipAm);
 foreach(var b in subL)
 a.Segments.Add(b);
 DefaultSubM.Segments.Remove(b);
 
 
 _context.SaveChanges();
 

I would need to take ChuckSize amount of segments from default Submodule to each new one. Is there a correct way to do it? , from what i know (little) , i would need to first add them to the context , save to get the Ids. then Take all but the first ChunkSize from the default one and add them to the second , then repeat for each one recursively.
Feel its a lot of code , and mess for this. Maybe i'm missing some magic way with linq or a method.

EDIT: Came up with this solution , but feels dirty and waaay more complex than it feels that should be...

EDIT2: Read somewhere i need to use Child.Parent = newParent Object.

c# entity-framework asp.net-core entity

share|improve this question

edited Mar 25 at 19:52

Rodrigo Chapeta

asked Mar 25 at 13:57

Rodrigo ChapetaRodrigo Chapeta

1444 bronze badges

public Modules splitModule(int id, string type, int amount){
 var ModuleSplit = _context.Modules.Include(x=>x.SourceLang).Where(x=>x.Id == id).FirstOrDefault();
 var DefaultSubM = _context.Submodules.Include(x=>x.Segments).Where(x=>x.ModuleId == ModuleSplit.Id).FirstOrDefault();
 List<Submodules> listToAdd = new List<Submodules>();
 if(type == "linguists")
 //linguists = rows / linguists , rounded 
 var rowAmount = DefaultSubM.Segments.Count();
 int chunkSize = rowAmount / amount ;

 for(int i=0 ; i< amount-1 ; i++)
 Submodules newSub = new Submodules();
 newSub.Status = Abr.Active;
 newSub.Token = Guid.NewGuid().ToString();
 listToAdd.Add(newSub);
 

 _context.Submodules.AddRange(listToAdd);
 _context.SaveChanges();

 var skipAm = rowAmount;
 if(rowAmount % amount != 0)
 skipAm++;
 

 foreach(var a in listToAdd)
 var subL = DefaultSubM.Segments.Take(rowAmount).Skip(skipAm);
 foreach(var b in subL)
 a.Segments.Add(b);
 DefaultSubM.Segments.Remove(b);
 
 
 _context.SaveChanges();
 

share|improve this question

edited Mar 25 at 19:52

Rodrigo Chapeta

asked Mar 25 at 13:57

Rodrigo ChapetaRodrigo Chapeta

1444 bronze badges

share|improve this question

edited Mar 25 at 19:52

Rodrigo Chapeta

asked Mar 25 at 13:57

Rodrigo ChapetaRodrigo Chapeta

1444 bronze badges

asked Mar 25 at 13:57

Rodrigo ChapetaRodrigo Chapeta

1444 bronze badges

asked Mar 25 at 13:57

Rodrigo ChapetaRodrigo Chapeta

1444 bronze badges