[dba-VB] VB.Net Database Classes

ACTEBS actebs at actebs.com.au
Thu Nov 24 07:43:24 CST 2011


Thanks Shamil. Am working through this very slowly...

Vlad

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov Shamil
Sent: Wednesday, 23 November 2011 7:32 PM
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] VB.Net Database Classes

Hi Vlad --

Sorry, I can't be of that much help - I'm very busy with custom development  these days and I do not have experience in working with mySQL via .NET/C#

I suppose basically you have to use .NET OleDb to implement CRUD operations - here is an introduction:

http://www.aspfree.com/c/a/Database/Database-Programming-in-C-Sharp-with-MySQL-Using-OleDB/

It's similar to using OleDb with other backend types including MS Access.

Folks say that using ADO.NET EF with mySQL is cumbersome:

http://stackoverflow.com/questions/76488/using-mysql-with-entity-framework

-- Shamil

23 ноября 2011, 05:05 от "ACTEBS" <actebs at actebs.com.au>:
> Hi Everyone,
> 
> To create this custom membership site, I would like to learn how to use and
> create database classes for the project and I'm hoping someone has the
> patience to guide me through it. I have tried searching on the web, but
> everyone is talking about classes, methods and properties but not about
> actual database access and data retrieval.
> 
> So basically my question is as follows. Suppose you have 2 tables in your
> database tblUsers and tblUsersRoles. The fields in these tables are:
> 
> <tblUsers>
> 
> UserID
> 
> RoleID
> 
> Username
> 
> UserEmail
> 
> UserPassword
> 
> UserCreated
> 
> UserLastLogin
> 
> <tblUsersRoles>
> 
> RoleID
> 
> RoleDescription
> 
> How would I create the classes for the above tables and also, how do I use
> these classes within the site as well? By use within the site I mean, how do
> I do the normal SELECT, UPDATE, ADD, DELETE functions, using the classes.
> 
> Many thanks
> 
> Vlad
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
> 

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com











More information about the dba-VB mailing list