There is already an object named 'tableName' in the database

Question

1.00/5 (2 votes)

See more:

There is already an object named 'tableName' in the database

i am working with wpf application and i want to create database with entity framework, i take this error. This error appears for table..

'There is already an object named '##tbl' in the database'

i have used 2 dll's in my wpf application
1. Microsoft.Kinect
2. Microsoft.Kinect.Wpf.Controls

if i remove this 2 dlls and run application for fresh database, then everything is going fine..

googled lot but found nothing, why on inclusion of those two dlls getting above exception..

really frustrated... Pls...

Posted 28-Dec-14 20:35pm

umesh_vn

Add a Solution

Comments

[no name] 29-Dec-14 4:49am

I think here you might be using the same table name each time. Try to use some different table name and try once.

umesh_vn 6-Jan-15 7:30am

thanks for reply.. i installed kinect runtime environment on same machine where i used to run kinect application..

Gold$Coin 6-Jan-15 22:27pm

It's better to use SQL Profiler, it will help you where exactly the query is getting executed and when. Hope it will help you to narrow down the problem.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Accepted Answer · 2015-01-08T07:35:00

I really believe that you have yourself provided the answer to your problem. The problem here is that inside your database 'tableName' is already present that you're trying to recreate. Which in turn creates an error in the logic and gives you this error.

Quote:
if i remove this 2 dlls and run application for fresh database, then everything is going fine..

Now when the database is a fresh version, that means there is no table with that name so it creates and the code goes fine.

I would like to make an advise that where ever you're trying to create this table or object, you must add a new if else block to create this table only if there is no table in the database. If there is a table, then it must skip this line.