BulkInsert not working

[Woudjee]

Why does this work?

List<BrepEntity> brepjes = new List<BrepEntity>();

for (int i = 0; i < 100; i++)
{
brepjes.Add(new BrepEntity()
{
Polygons = new List<PolygonEntity>()
{
new PolygonEntity()
{
Vertices = new List<VectorEntity>()
{
new VectorEntity() { X = 123, Y = 2348.324f, Z = 234293784.1f },
}
},
new PolygonEntity()
{
Vertices = new List<VectorEntity>()
{
new VectorEntity() { X = 334, Y = 244648.324f, Z = 909793784.1f },
}
}
}
});
}

Stopwatch stopwatch = Stopwatch.StartNew();
_context.BulkInsert(brepjes, options => options.IncludeGraph = true);
_context.BulkSaveChanges();

stopwatch.Stop();
return stopwatch.ElapsedMilliseconds;

But this does not?

List<GridInfoEntity> test = new List<GridInfoEntity>()
{
new GridInfoEntity()
{
GridInfoX = new List<GridInfoXEntity>()
{
new GridInfoXEntity("Label", 123),
},
GridInfoY = new List<GridInfoYEntity>()
{
new GridInfoYEntity("Label", 456),
},
GridInfoZ = new List<GridInfoZEntity>()
{
new GridInfoZEntity("Label", 789),
},
}
};

Stopwatch stopwatch = Stopwatch.StartNew();
_context.BulkInsert(test, options => options.IncludeGraph = true);
_context.BulkSaveChanges();

stopwatch.Stop();
return stopwatch.ElapsedMilliseconds;

I am getting this error, which is incorrect:

Missing Column : GridInfoId
On entity : GridInfoXEntity
On Table : [Domain].[GridInfo]

[Woudjee]

If I use AddRange for the not working example, it works. I am therefore sure that both the tables and columns exist.

[Woudjee]

After 13 hours of testing and 14 minutes after making this post, I figured out the problem. BulkInsert cannot handle schemas!

[Table("GridInfo", Schema = "Domain")]

When I removed this line of code, it worked. Perhaps you want to check that out.

[borisdj]

Could you add entire code of class GridInfoEntity and GridInfoZEntity or write a Test for the issue.

[Woudjee]

Yes, of couse. See below (screenshot for readability + copy paste):

GridInfoEntity

[Table("GridInfo", Schema = "Domain")]
public class GridInfoEntity : Entity
{
public virtual ICollection GridInfoX { get; set; }
public virtual ICollection GridInfoY { get; set; }
public virtual ICollection GridInfoZ { get; set; }
}

GridInfoXEntity

[Table("GridInfo.X", Schema = "Domain")]
public class GridInfoXEntity : Entity
{
public GridInfoXEntity(string label, float value)
{
ValueX = value;
Label = label;
}

public GridInfoXEntity()
{

}

public float ValueX { get; set; }
public string Label { get; set; }

public virtual GridInfoEntity GridInfo { get; set; }

}

Exactly the same applies to the Y and Z variant (I double checked in my code).

And for the Brep-chain:

BrepEntity

public class BrepEntity : Entity
{
public virtual ICollection Polygons { get; set; }
}

PolygonEntity

public class PolygonEntity : Entity
{
public int BrepId { get; set; }
public virtual BrepEntity Brep { get; set; }
public virtual ICollection Vertices { get; set; }
}

VectorEntity

public class VectorEntity : Entity
{
public float X { get; set; }
public float Y { get; set; }
public float Z { get; set; }

public int PolygonId { get; set; }
public virtual PolygonEntity Polygon { get; set; }

}

[Woudjee]

The only difference appears to be the schema. Once I removed it, everything worked as expected. And I remember from last week that I got exception that actually used the schema name. It said that the schema name did not exist (while it definitely did). I guess somewhere in your code, you are not handling schemas. Is that possible?

For now, I disabled schemas in my code base (hopefully temporarily, because my database is not nicely structured anymore when viewing it in SMSS).

[borisdj]

Schemas are actually supported with main Bulk ops.
But IncludeGraph often had exceptions.
I will lookup into it more.
In the meantime you could try to call 2 times BulkInsert, instead of using IncludeGraph.

[Woudjee]

How do you mean that exactly? I interpreted IncludeGraph as: include all children so that all gets added. In this particular example, you mean storing the X-values, Y-values, Z-values and grid infos themselves as separate calls?

I guess that would work here, but in my actual project this would get too messy (I have referred a different post 38 minutes ago). I can live with not having schemas for the time being.

[borisdj]

Yes, that's right.

[Woudjee]

Thank you Boris for you quick replies. I will keep an eye on this post and would be more than happy to contribute to solving this problem wherever I can. Just let me know.