Bulkinsert unable to access destination table [].[table]
up vote
0
down vote
favorite
Edit: Fixed.
However, i do kinda feel like an idiot. The table i was inserting to did not have a primary key specified. However given the error message i was given, this was not something i thought of.
We currently have a table in a schema. Lets call that Stock. In that schema there is a table called Data. So [Stock].[Data].
When using BulkInsert from EntityFramework.Extensions however, we get the following error message: Cannot access destination table '.[Data].
As you can see, the Schema is missing. However i cannot find any way to add it. The model is autogenerated from the database using EntityFramework.
The user has access to the table
using(StockEntities context = new StockEntities())
{
var entities = AutoMapper.Mapper.Map<List<Data>>(listData).ToArray();
context.BulkInsert(entities);
context.SaveChanges();
}
In regards to the question below, the model has been set up in the following way. I have already tried changing the database scheme name (which was set to dbo) and the namespace from stock to stockmodel. However, it still wont work.
c# entity-framework bulkinsert
asked Nov 19 at 8:21
Vincentw
9719
add a comment |
up vote
0
down vote
favorite
Edit: Fixed.
However, i do kinda feel like an idiot. The table i was inserting to did not have a primary key specified. However given the error message i was given, this was not something i thought of.
We currently have a table in a schema. Lets call that Stock. In that schema there is a table called Data. So [Stock].[Data].
When using BulkInsert from EntityFramework.Extensions however, we get the following error message: Cannot access destination table '.[Data].
As you can see, the Schema is missing. However i cannot find any way to add it. The model is autogenerated from the database using EntityFramework.
The user has access to the table
using(StockEntities context = new StockEntities())
{
var entities = AutoMapper.Mapper.Map<List<Data>>(listData).ToArray();
context.BulkInsert(entities);
context.SaveChanges();
}
In regards to the question below, the model has been set up in the following way. I have already tried changing the database scheme name (which was set to dbo) and the namespace from stock to stockmodel. However, it still wont work.
c# entity-framework bulkinsert
asked Nov 19 at 8:21
Vincentw
9719
i believe you can re-generate from the db specifying a schema - try doing a google around that
– JohnB
Nov 19 at 8:29
I have updated the question, is that what you meant?
– Vincentw
Nov 19 at 8:45
I would check to see if the table was generated in the database. Use SQL Server Management Studio (comes with SQL Server) and verify using the SSMS explorer that the table was generated in the database and the columns are properly defined.
– jdweng
Nov 19 at 10:03
The table exists in the database (created in myself). However, it has been created first using a select into statement instead of a normal create table method due to the number of fields.
– Vincentw
Nov 19 at 10:07
I'm the owner of Entity Framework Extensions, I recommend you to send yourEDMXfile and the create table script to our support team directly: info@zzzprojects.com, otherwise, please check using SQL Profiler what the script that is executed is, you might miss some other schema name change.
– Jonathan Magnan
Nov 19 at 12:27
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Edit: Fixed.
However, i do kinda feel like an idiot. The table i was inserting to did not have a primary key specified. However given the error message i was given, this was not something i thought of.
We currently have a table in a schema. Lets call that Stock. In that schema there is a table called Data. So [Stock].[Data].
When using BulkInsert from EntityFramework.Extensions however, we get the following error message: Cannot access destination table '.[Data].
As you can see, the Schema is missing. However i cannot find any way to add it. The model is autogenerated from the database using EntityFramework.
The user has access to the table
using(StockEntities context = new StockEntities())
{
var entities = AutoMapper.Mapper.Map<List<Data>>(listData).ToArray();
context.BulkInsert(entities);
context.SaveChanges();
}
In regards to the question below, the model has been set up in the following way. I have already tried changing the database scheme name (which was set to dbo) and the namespace from stock to stockmodel. However, it still wont work.
c# entity-framework bulkinsert
asked Nov 19 at 8:21
Vincentw
9719
Edit: Fixed.
However, i do kinda feel like an idiot. The table i was inserting to did not have a primary key specified. However given the error message i was given, this was not something i thought of.
We currently have a table in a schema. Lets call that Stock. In that schema there is a table called Data. So [Stock].[Data].
When using BulkInsert from EntityFramework.Extensions however, we get the following error message: Cannot access destination table '.[Data].
As you can see, the Schema is missing. However i cannot find any way to add it. The model is autogenerated from the database using EntityFramework.
The user has access to the table
using(StockEntities context = new StockEntities())
{
var entities = AutoMapper.Mapper.Map<List<Data>>(listData).ToArray();
context.BulkInsert(entities);
context.SaveChanges();
}
In regards to the question below, the model has been set up in the following way. I have already tried changing the database scheme name (which was set to dbo) and the namespace from stock to stockmodel. However, it still wont work.
c# entity-framework bulkinsert
c# entity-framework bulkinsert
asked Nov 19 at 8:21
Vincentw
9719
asked Nov 19 at 8:21
Vincentw
9719
edited Nov 19 at 12:13
asked Nov 19 at 8:21
Vincentw
9719
asked Nov 19 at 8:21
Vincentw
9719
asked Nov 19 at 8:21
Vincentw
9719
9719
i believe you can re-generate from the db specifying a schema - try doing a google around that
– JohnB
Nov 19 at 8:29
I have updated the question, is that what you meant?
– Vincentw
Nov 19 at 8:45
I would check to see if the table was generated in the database. Use SQL Server Management Studio (comes with SQL Server) and verify using the SSMS explorer that the table was generated in the database and the columns are properly defined.
– jdweng
Nov 19 at 10:03
The table exists in the database (created in myself). However, it has been created first using a select into statement instead of a normal create table method due to the number of fields.
– Vincentw
Nov 19 at 10:07
I'm the owner of Entity Framework Extensions, I recommend you to send yourEDMXfile and the create table script to our support team directly: info@zzzprojects.com, otherwise, please check using SQL Profiler what the script that is executed is, you might miss some other schema name change.
– Jonathan Magnan
Nov 19 at 12:27
add a comment |
i believe you can re-generate from the db specifying a schema - try doing a google around that
– JohnB
Nov 19 at 8:29
I have updated the question, is that what you meant?
– Vincentw
Nov 19 at 8:45
I would check to see if the table was generated in the database. Use SQL Server Management Studio (comes with SQL Server) and verify using the SSMS explorer that the table was generated in the database and the columns are properly defined.
– jdweng
Nov 19 at 10:03
The table exists in the database (created in myself). However, it has been created first using a select into statement instead of a normal create table method due to the number of fields.
– Vincentw
Nov 19 at 10:07
I'm the owner of Entity Framework Extensions, I recommend you to send yourEDMXfile and the create table script to our support team directly: info@zzzprojects.com, otherwise, please check using SQL Profiler what the script that is executed is, you might miss some other schema name change.
– Jonathan Magnan
Nov 19 at 12:27
i believe you can re-generate from the db specifying a schema - try doing a google around that
– JohnB
Nov 19 at 8:29
i believe you can re-generate from the db specifying a schema - try doing a google around that
– JohnB
Nov 19 at 8:29
I have updated the question, is that what you meant?
– Vincentw
Nov 19 at 8:45
I have updated the question, is that what you meant?
– Vincentw
Nov 19 at 8:45
I would check to see if the table was generated in the database. Use SQL Server Management Studio (comes with SQL Server) and verify using the SSMS explorer that the table was generated in the database and the columns are properly defined.
– jdweng
Nov 19 at 10:03
I would check to see if the table was generated in the database. Use SQL Server Management Studio (comes with SQL Server) and verify using the SSMS explorer that the table was generated in the database and the columns are properly defined.
– jdweng
Nov 19 at 10:03
The table exists in the database (created in myself). However, it has been created first using a select into statement instead of a normal create table method due to the number of fields.
– Vincentw
Nov 19 at 10:07
The table exists in the database (created in myself). However, it has been created first using a select into statement instead of a normal create table method due to the number of fields.
– Vincentw
Nov 19 at 10:07
I'm the owner of Entity Framework Extensions, I recommend you to send your
EDMX file and the create table script to our support team directly: info@zzzprojects.com, otherwise, please check using SQL Profiler what the script that is executed is, you might miss some other schema name change.– Jonathan Magnan
Nov 19 at 12:27
I'm the owner of Entity Framework Extensions, I recommend you to send your
EDMX file and the create table script to our support team directly: info@zzzprojects.com, otherwise, please check using SQL Profiler what the script that is executed is, you might miss some other schema name change.– Jonathan Magnan
Nov 19 at 12:27
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53370741%2fbulkinsert-unable-to-access-destination-table-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
i believe you can re-generate from the db specifying a schema - try doing a google around that
– JohnB
Nov 19 at 8:29
I have updated the question, is that what you meant?
– Vincentw
Nov 19 at 8:45
I would check to see if the table was generated in the database. Use SQL Server Management Studio (comes with SQL Server) and verify using the SSMS explorer that the table was generated in the database and the columns are properly defined.
– jdweng
Nov 19 at 10:03
The table exists in the database (created in myself). However, it has been created first using a select into statement instead of a normal create table method due to the number of fields.
– Vincentw
Nov 19 at 10:07
I'm the owner of Entity Framework Extensions, I recommend you to send your
EDMXfile and the create table script to our support team directly: info@zzzprojects.com, otherwise, please check using SQL Profiler what the script that is executed is, you might miss some other schema name change.– Jonathan Magnan
Nov 19 at 12:27