MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

Adding and Accessing New Database Table  (Mono Support )

Viewed 5541 time(s), 2 post(s) 11/10/2014 7:22:57 AMby Apocalypse
Apocalypse

Apocalypse

11/10/2014 7:22:57 AM
I would like to create a new table in the MonoX database which i can achieve using SQL Developer or MS SQL Server Management Studio. Assume the table is called "dbo.Foo" and has the following columns 

ID (PK, UniqueIdentifier, not null),
UserId (FK, UniqueIdentifier, not null),
Title (nvarchar(100), not null),

how would i utilize the DAL/IDataAccessAdapter/ LLBLGen Adapter Template to access this table in the Database? Thanks in Advance
This content has not been rated yet. 
177 Reputation 14 Total posts
idrazic

idrazic

11/10/2014 10:11:17 AM
Hi, 

You would need a licence for regenerating MonoX DAL. See here:
https://github.com/MonoSoftware/MonoX-Data-Access-Layer

Afterwards you can use GenericRepository  to access your table.

Please not that nothing stops you from using something else to work with the database (eg System.Data.SqlClient directly).

Regards,
Igor
This content has not been rated yet. 
1384 Reputation 152 Total posts