troubleshooting Question

(VS Newbie) Why am i getting .sdf instead of .mdf?

Avatar of lopband
lopband asked on
.NET ProgrammingC#
5 Comments1 Solution765 ViewsLast Modified:
I am learning visual studio and C#

going through a tutorial it tells me to right click on the project name, then select add new item, then sql database.. and looking at what he is getting looks like a .mdf database, and under that "Database Diagrams", "views"  etc
but when i try to do the same i dont have those options (i think his example was using 2005 while i am using 2008)

When I right click on the project name, then select add new item, I am only getting the option of "Local database"
once i select that i am getting a .sdf , and no "database diagrams"
(and thus i have no idea how to add a foreign key etc or follow along with the tutorial)

Please help/advise.


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros