[AccessD] Examples In Best Coding VB.net

[Dan Waters]

Hi Paul,

I've been learning VB.Net over the last few years after many years of Access development - so I thought I'd through in my 2 cents.

First - C# vs. VB.Net.  Beginning about 2008, MS began a concerted effort to make the two languages functionally equivalent.  Prior to this there were significant capabilities that one language had over the other.  By now most of those significant differences have been resolved so your choice is a preference - with an important caveat.  

C# is used by most development shops.  If you're thinking of getting a job developing then C# is the better choice for that reason.  But if you're mostly going to work for yourself then VB.Net might be better.  For me starting with VB.Net was good because I didn't have to deal with a new syntax (C# really is overly complicated and VB.Net really is more readable) and only had to learn more about classes and the differing capabilities between the VBA and VB.Net.

I also made the choice to use LINQ as the data layer between my application and SQL server.  And this is really the way to go.  It gives you intellisense while you're writing code for CRUD operations and you'll get error indicators on-screen if you've done something wrong.  Also - buy a copy of LINQPad Pro - it's a great sandbox for writing LINQ queries.  LINQ resolves to optimized SQL language to give you great performance.  

You'll find many helpful discussions on-line about how to write code a certain way.  I've found that if I begin the google search with "vb.net" [question here] then the answers written in VB.Net show up first on the list, but C# answers will also show up down the list.  Best of both ...  You can also copy a C# example on screen and convert it to vb.net using converter.telerik.com or www.developerfusion.com or others.

Also, I have a copy of SharpDevelop version 4.4.  This has a conversion feature to go back and forth between C# and VB.Net.  Just open a solution or project in SharpDevelop, right-click on a project, and select the conversion you want.  A duplicate project is then created in the selected language.  The latest version of SharpDevelop (5) does not have this conversion feature.

One more thing - databaseadvisors.com has an email list for Visual Studio (dba-VS)!

Good Luck!
Dan

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland via AccessD
Sent: Thursday, October 20, 2016 2:12 AM
To: Access List; Development in Visual Studio
Cc: Paul Hartland
Subject: [AccessD] Examples In Best Coding VB.net

To all,

Being self-taught and not had much time to actually spend with VB.net I now find myself with a little time to try and learn it properly, don;t really want to go through a step-by-step learning process, I seem to be able to pick things up quicker through working examples etc.  So could anyone point me in the right direction for (should I say) best coding examples, doesn't have to be massive just would like to see the best and most effiicient ways to link even a single form to a SQL Server BE, say a name and address form.  I have looked using searches and so many examples out there with different ways, but I trust the people on here to guide me in the right direction, as I believe just a simple form that will show me the best way to select, update, delete and insert records is enough to start me.

The reason I am after this is that I have a Access manufacturing process application dedicated to a certain industry and want to rewrite it in vb.net and SQL as well, I could probably get something up and running but want it to be as slick as it can be as I may look at selling it afterwards.

Thank you so much for any help in advance.

--
Paul Hartland
paul.hartland at googlemail.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com