Click here to Skip to main content
15,892,005 members
Articles / Programming Languages / C#

Using a LLBLGen-generated data-access tier

Rate me:
Please Sign up or sign in to vote.
4.82/5 (18 votes)
24 Aug 2002BSD9 min read 323.9K   7.7K   109  
An article which describes how to use the data-access tier, generated by the free, open source data-access tier generator for .NET: LLBLGen. The sourcecode for LLBLGen v1.2 in C# is included, plus the generated data-access tier used in this article (C# and T-SQL) and the creation script for the data
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > 
<HTML>
<HEAD>
<TITLE>LLBLGen::GUI: Connection tab</TITLE>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 7.0">
<link rel="STYLESHEET" type="text/css" href="general.css">
</HEAD>
<BODY>
<br>
<h3>LLBLGen::GUI: Connection tab</h3>
<br>
<p align="center">
	<img src="sshot_connection.gif" border="0">
	<p class="SmallFontREF" align="center">
		<b>The connection tab.</b>
	</p>
</p>
<p>
	This is the startup screen of the application. Initially only this tab is enabled in the GUI, to let the user
	focus on this step first before proceeding with the rest of the actions.
	<br><br>
	<b class="SmallHdr">The tab's controls and their meaning</b><br>
	<ul>
		<li><b>SQL Server</b>.<br>The name of the SQL Server machine to connect to. LLBLGen will use this value as the 
			server name in the connection string, so it's wise to create a 
			client alias first, using the Client Network Utility, shipped with 
			SQL Server. </li>
  		<li><b>Catalog</b>.<br>The catalog name (database name) to generate the data-access tier for. </li>
  		<li><b>Windows Authentication</b>. <br>One of the two radiobuttons in this group. When selected, LLBLGen will use 
			NT-security ('Integrated security') to connect and use the catalog mentioned in the 'Catalog' textbox. 
			The current user is used to connect to the SQL Server. Be sure that you have 
			the proper credentials to connect and use the data in the SQL Server you want 
			to connect to.</li>
  		<li><b>SQL Server Authentication</b>.<br>One of the two radiobuttons in this group. When the SQL 
			Server instance is installed with mixed mode security, you can use this option and supply a 
			SQL Server login with password to connect to and use the catalog suggested. 
			When this radiobuton is selected, the SQL Server credentials group is enabled.</li>
  		<li><b>SQL Server credentials: LoginID</b>.<br>The LoginID to use for the SQL Server authentication. </li>
  		<li><b>SQL Server credentials: Password</b>.<br>The Password belonging to the LoginID supplied with 'LoginID'.</li>
  		<li><b>Connect</b>. Clicking this button will make LLBLGen connect to the SQL Server instance supplied with the 
			authentication method and parameters selected. When a succesful connection 
			could be established, the definitions of all tables and views are read from the catalog suggested and 4 
			tabs are added to the GUI. This button will then be disabled and the 'Disconnect' button will be enabled. </li>
  		<li><b>Disconnect</b>.<br>Disconnect from the current connected SQL Server and catalog. All tabs except the 
			Connection tab are removed from the GUI and this button is disabled. The 
			Connect button is enabled again.</li>
	</ul>
</P>
<div align="right" class="SmallFontTOC">
	<hr size="1" width="60%" align="right">
	LLBLGen v1.2 documentation. &copy; 2002 <a href="http://www.sd.nl/" target="_blank">Solutions Design</a>
</div>
<br><br><br>
</BODY>
</HTML>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The BSD License


Written By
Web Developer
Netherlands Netherlands
Senior Software Engineer @ Solutions Design, a company for internet- and intranet applications, based in The Hague, Netherlands. B.Sc. in Computer Science.

Developer of LLBLGen and LLBLGen Pro. http://www.llblgen.com

Comments and Discussions