Hi all,
i created a database in VS2013 as
project->add new item->service based database->name->employee.mdf----add
and i open this in solution explorer and opened it as database explorer
but when i right click on the table it doesn't shows add new table it shows only refresh and properties
my problem is that how to add new table in employee database
please reply asap
thanks in advance
swati smitaPosted Mar 17, 2016, 5:37 AM
Hemant SharmaPosted Jul 8, 2014, 3:55 AM
Thanks for reply to all
@Srikanth:
but there is not a issue with connection ,
instead of that i want to know how to find option for adding tables
since i right clicked on the explored employee.mdf's table but it doesn't shows add table(it shows only refresh & blank properties options).
Yadlapalli SrikanthPosted Jul 8, 2014, 2:40 AM
2. Right click on Dataconnections
3.Select AddConnection and then select Microsoft Sqlserver Database File.
4. Browse the MDF file and add it.
5. Now you can find the MDF as one of the Database you can create table here.
Nimit JoshiPosted Jul 8, 2014, 2:09 AM
Please install it from the following link:
Sql Server Data Tools for Visual Studio 2013
Guest UserPosted Jul 8, 2014, 12:34 AM
But you can try to open employee.mdf in MS-Access also and add table there.
twitter @sumitjolly