Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > .NET 4.5.1 and Visual Studio 2013 > .NET 4.5.1 and Visual Studio 2013 General Discussions
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
.NET 4.5.1 and Visual Studio 2013 General Discussions For discussing anything about .NET 4.5.1, WPF, WCF, the rest of the .NET 4.5.1 Framework, and Visual Studio 2013 that isn't about a specific Wrox book. Please post code questions about a specific language (C#, VB, ASP.NET, etc) in the correct language forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the .NET 4.5.1 and Visual Studio 2013 General Discussions section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 7th, 2014, 05:35 PM
Authorized User
Points: 44, Level: 1
Points: 44, Level: 1 Points: 44, Level: 1 Points: 44, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2014
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Question Learning Entity Framework 6, visual basic .net 2013

I am learning .NET do develop a business (data-centric) application in VB .NET and VS2013 Express.
It will have 3-Tier architecture. For the Data layer (working against a SQLServer Database, or MySQL, or generally speaking, against any relational DB), I am thinking of using Entity Framework (latest version, 6.0, I believe), to handle the decouplement between relational-design and class-based-design.

I would like to hear opinions about my choice and sources for learning (tutorials, books,...), but in VB.

Another opinion I would like to hear about is Stored-Procedures yes or not. I would like to avoid them, but maybe I am too drastic.

I don't know if MVC is related to what I am exposing here, but I prefer to avoid that component or approach.

thanks
  #2 (permalink)  
Old August 7th, 2014, 09:52 PM
Friend of Wrox
Points: 528, Level: 8
Points: 528, Level: 8 Points: 528, Level: 8 Points: 528, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2014
Posts: 136
Thanks: 1
Thanked 10 Times in 10 Posts
Default

In my opinion the entity frame work and linq to entities is one of the greatest frame works to hit the development scean in a long time. it greatly decouples data access and perstance from your application devlopement and you end up spending more time where it realy counts i.e. the presentation and bussiness tiers.

In todays data centric applications; robost and dynamic slns are the key and the entity framework offers all that is needed to write complex data access but in the language that you excell in i.e. C# or VB.

stored procedure have there place, but in my exprience with data centric sites i find them more cumbersome than helpful.

a pet peave of mine when working on an application that was stored procedure driven, is when i go write some presentation for some data that is currently no there and i end up writing code in 3 different layer to get there i.e. the presentation layer, bussiness layer, and the back in plumbing. with the entity frame you see with a quick adjustment to you linq to entities query and if you have properly set up data binding you have only changed code in one place. not only does it allow for minimal coding, but in your bussiness logic you find that if you needed a simple query to get one more peice or data that you did not forsee, well with the entity frame work its childs play to get it, with a stored procedure diven application you have write all supporting logic and store procedure to get that information.

another benni is that the entity frame work makes paging data a snap for binding to paged gridviews.

i.e.
MyDBContex.MyTable.Skip( pageNumber * rowsInpage ).Take( rowsInpage );

and no sql or stored procedure written.


to do a simple data transform on the query
MyDBContex.MyTable.Skip( pageNumber * rowsInpage ).Take( rowsInpage ).Select( r => new { Filed1 = r.Field1, Field2 = r.Field2 } )

and again no sql or stored procedure written but i have different view of the same data.


so in conclusion for data scentric site i have to put a thumbs up for entity frame work and thumbs down for stored procedure.

the book that i use as my bible for linq ( and in my opinion is the heart of entity frame work ) is Pro linq and it comes in C# or VB, it really gives you an understanding of the power of this framework.

as for getting in the front end of entity frame work i.e. code first, model first and the such any book on entity frame work 4 and up should give you the needed information to get going with setting up your data models.

for some stellar tutorial check out www.asp.net

Last edited by mmorgan30; August 7th, 2014 at 10:02 PM.
  #3 (permalink)  
Old August 8th, 2014, 04:22 AM
Authorized User
Points: 44, Level: 1
Points: 44, Level: 1 Points: 44, Level: 1 Points: 44, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2014
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks a lot. I have downloaded the Pro Linq and will start my journey on the subject.

I have checked asp.net as you suggested, and see many examples of combining EF6 and MVC... I don't know what MVC is, but for what I read, I would prefer to avoid it. I mean that I wish to use EF6 but NOT use MVC, if this is makes any sense.

My approach (Code/Model/DB) is DB, since I am used to think in "relational" terms. From the DB I will de-normalize to get classes / datasets (or whatever) that are useful for the work to be done in BL and Presentation Layers (for instance, members with overdue bills, or members of a certain sport, or any person in DB except suppliers,....)

thanks again
  #4 (permalink)  
Old August 8th, 2014, 11:23 AM
Friend of Wrox
Points: 528, Level: 8
Points: 528, Level: 8 Points: 528, Level: 8 Points: 528, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2014
Posts: 136
Thanks: 1
Thanked 10 Times in 10 Posts
Default

MVC (model, view, controller) is another flavor of project set up. I my self prefer ASP.net web pages over MVC, but it is the latest craze.

You can use entity frame work with any application type, it is project independent.

Last edited by mmorgan30; August 8th, 2014 at 11:37 AM.
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
PLEASE HELP WITH THE ERROR IN Chapter 14 LINQ and the ADO.NET Entity Framework Tobi BOOK: Beginning ASP.NET 4 : in C# and VB 2 February 19th, 2014 08:03 AM
add record in multiple table on one button using asp.net 4.0 and entity framework Aparna Bhise ASP.NET 4 General Discussion 0 June 29th, 2011 09:46 AM
Chapter 14 Linq and ado.net entity framework pandukal21 BOOK: Beginning ASP.NET 4 : in C# and VB 8 January 28th, 2011 05:19 AM
Visual Studio .NET 2003 with .NET 2 Framework testsubject VS.NET 2002/2003 1 July 27th, 2006 04:25 PM



All times are GMT -4. The time now is 03:25 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.