 |
BOOK: Beginning ASP.NET 4.5.1 : in C# and VB
 | This is the forum to discuss the Wrox book Beginning ASP.NET 4.5.1: in C# and VB by Imar Spaanjaars; ISBN: 978-1-118-84677-3 |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the BOOK: Beginning ASP.NET 4.5.1 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
|
October 30th, 2015, 07:51 PM
|
|
Authorized User
|
|
Join Date: Oct 2015
Posts: 58
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
Chap 12, p411 - Creating the SQL Server Sample Database
Hi again Imar,
I've had the same problem as many others with accessing the (LocalDB)\v11.0 in the SMSS's.
I've installed SQLServer 2014, 2012 full, 2012 Express, and it seems that none of them installed LocalDB.
I tried to download it apart, but (see image, well I cannot attach images here?) it says:
"Microsoft SQL Server 2012 Express LocalDB"
"Installation of this product failed because it is not supported on this operating system. For more information..."
My machine is Windows 8.1.
I have installed Visual Studio Community 2015
And SQL Server 2012
Are they a good formula?
Can I keep doing the next chapters without any contact with SQL Server, and only using your source .mdf files?
Thanks for the help.
PS: I think for developers who only want to refer to tryouts, maybe the next edition you can include an index for the # of tryouts.
|
|
October 31st, 2015, 06:23 AM
|
|
Authorized User
|
|
Join Date: Oct 2015
Posts: 58
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
Well, I had to download the 6GB!! version of Visual Studio 2013, to get the SQL Express LocalDB, and it worked! Also I change in the Web. config the Data source from (LocalDB)\v11.0 to (LocalDB)\MSSQLLocalDB in the connectionStrings.
Now I have access to LocalDB with the SQL Server 2012 that came with VS2013, but still using with VS2015.
I didn't need to reinstall Windows as some post on the Internet said or to do a workaround.
Hope this works for others too.
|
|
October 31st, 2015, 06:24 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Have you tried connecting to (LocalDB)\v12.0? That's the version installed with VS 2015.
Cheers,
Imar
|
|
October 31st, 2015, 07:14 PM
|
|
Authorized User
|
|
Join Date: Oct 2015
Posts: 58
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
Hi, I tried with (LocalDB)\v12.0, didn't work.
It seems that VS2015 can see the DBs, but in the SQL Server Object Explorer, which I tried to drag a table from, but it dragged it as <p> element... and still considering installing VS2013.
I'm stuck in the step 6, p444
Greetings.
|
|
November 1st, 2015, 12:37 AM
|
|
Authorized User
|
|
Join Date: Oct 2015
Posts: 58
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
Well, as I promised I went back to VS2013... and yes, my predictions were right, Now I can keep working on these tryouts (Chapter 12 forward) "smoothly", hope until the end of the book and beyond.
Thanks.
|
|
November 1st, 2015, 12:27 PM
|
|
Authorized User
|
|
Join Date: Oct 2015
Posts: 58
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
Although I can preview the results of the pages that work with databases(db) in the localhost/, I cannot view the db's in the server explorer of VS2015 because it says is not compatible with the current SQL Server version (2014), so I work with VS2013 when I need to add tables or similar and SQL Server 2012. In fact I had to attach the PlanetWrox to locallb/v.11.0 afterwards due to the experiments I did to find the version of SQL/VS that works for my machine from the chapter 12.
|
|
November 1st, 2015, 02:38 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
>> but in the SQL Server Object Explorer, which I tried to drag a table from
You need the Database Explorer (called the Server Explorer on full versions of Visual Studio) and not the SQL Server Object Explorer.
Cheers,
Imar
|
|
November 1st, 2015, 03:09 PM
|
|
Authorized User
|
|
Join Date: Oct 2015
Posts: 58
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
Thanks Imar, I saw the difference, that's why now I understand VS2015 works well with SQL Server 2014, but not with the 2012 version. That's why I installed the VS2013 to not waste time figuring out compatibility issues, I'm interested more in learning the concepts and tools of the VS environment.
By the way, How long did it take you to write the book? For me looks like a year at least.
Thanks for the help,
PS:
Here is an example of the idea I told you yesterday for future editions, to put like an index for the tryouts. I put 3 stars (*) when I finished that tryout to keep record where I am.
Chap14
489***/LINQ to Entities Example
501***/Queries and Anonymous Types
505***/Model Binding = Using SQL Server to add new tables
513***/Inserting and Deleting Data with ListView
523***/Strongly Typed Data-Bound
|
|
November 1st, 2015, 03:59 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Aren't all the TIO's listed in the main Index?
Cheers,
Imar
|
|
November 1st, 2015, 04:15 PM
|
|
Authorized User
|
|
Join Date: Oct 2015
Posts: 58
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
Well, not exactly. Sometimes the title of the TIO's does not match with what's in the index (main). And at least for me that I'm trying to follow the sequence, my only reference is the page#. Maybe putting a number to the TIO could clarify if want to do it again.
|
|
|
|
button below this post to show your appreciation!
