Salakhetdinov Shamil
mcp2004 at mail.ru
Wed Nov 23 02:32:06 CST 2011
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 > >