Articles in the VB.Net Category
.Net, Programming, VB.Net »
Today we have seen most of the data access layers on the web. Here I have placed some peace of simple Data Access class for your use. This will helpful if you are using quires. This will not useful for stored procedures. You simply form the query and call the ExecuteQuery function.
Class Methods and properties:
ExecuteQueryMode-Enumarator type of Execute Query Mode.
GetConnectionString () – Get the Connection string from the connectionStrings part of the Config file.
CreateConnectionObject () – To create the Connection Object
OpenConnectionObject () – Open the Connection
CloseConnectionObject () …
.Net, Database, Programming, SQL Programming, VB.Net »
The Visual Basic.Net doesn’t contain the refactoring which is one of the major advantages for the C# programmers. Often I miss the Encapsulate Field feature in VB.Net which helps us for geneting public properties of a class and associated Get & Set methods. Initially I had a thought of doing a code fragment in VB.Net for parsing private data members and automatically generating public properties along with their Set and Get methods.
The hardcore requirement of encapsulation (in Re-factoring) of private members with public properties comes in the Entity class in …
