July 25, 2008 11:06am pdt

1. TheLearn... 242,325
2. Dhaest 121,082
3. jaime_oliv... 89,921
4. jcoehoorn 89,257
5. naspinski 66,290
6. GreenGho... 66,010
7. raterus 61,450
8. samtran0... 57,795
9. emoreau 56,675
10. jpaulino 55,070
11. Velio 53,140
12. ZachSmith 46,850
13. angelIII 42,763
14. webtubbs 39,960
15. avnish_t... 39,850

1. TheLearn... 608,703
2. samtran0... 237,110
3. Dhaest 206,605
4. surajguptha 199,472
5. jaime_oliv... 168,006
6. Idle_Mind 155,895
7. emoreau 125,810
8. jcoehoorn 107,557
9. JimBrandley 101,222
10. Fernando... 95,534
11. jpaulino 92,900
12. McExp 89,513
13. DarkoLord 87,876
14. GreenGho... 87,260
15. angelIII 81,667

01.21.2008 at 05:12AM PST, ID: 23098054

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.6

Auto Generate BLL for xsd DAL

Zones: .NET Framework 2.0, C# Programming Language, Programming for ASP.NET

Tags: asp.net 2.0, c#

Hi,

I've seen in many asp.net 2.0 projects this sample of code (same structure I mean). All projects are using XSD as data access layer and this BLL class just creates instances of strong typed datasets created by the xsd. I was wondering after I add an XSD and add a new table over there how do I auto generate this code? I mean where do I take this code from, for these classes which create instances of the xsd datasets which can be used as business logic classes?
I don't think that this code was manually written cause it looks exactly the same on all projects I saw by different coders.

Thanks,
Sagi

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:

           
           
             using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using SmartestTableAdapters;
 
namespace RealTech
{
	[System.ComponentModel.DataObject]
	public class Users
	{
		//============================================================================//
		// PROPERTIES
		//============================================================================//
 
		/// <summary>
		/// Property
		/// Name: Adapter
		/// Type: TableAdapter
		/// </summary>
 
		private ST_USERSTableAdapter _Adapter = null;
		protected ST_USERSTableAdapter Adapter
		{
			get
			{
				if (_Adapter == null)
					_Adapter = new ST_USERSTableAdapter();
				return _Adapter;
			}
		}
		
		//============================================================================//
		// FUNCTIONS
		//============================================================================//
 
		/// <summary>
		/// Function
		/// Name: SelectUsers
		/// Desc: Select all
		/// </summary>
 
		[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false)]
		public Smartest.ST_USERSDataTable SelectUsers()
		{
			return this.Adapter.SelectUsers();
		}
 
		/// <summary>
		/// Function
		/// Name: SelectUsers
		/// Desc: Select by ID
		/// </summary>
 
		[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false)]
		public Smartest.ST_USERSDataTable SelectUsers(int USER_ID)
		{
			return this.Adapter.SelectUserByID(USER_ID);
		}
 
		/// <summary>
		/// Function
		/// Name: SelectUsers
		/// Desc: Select by Name
		/// </summary>
 
		[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false)]
		public Smartest.ST_USERSDataTable SelectUsers(string USER_NAME)
		{
			return this.Adapter.SelectUsersByName(USER_NAME);
		}
 
		/// <summary>
		/// Function
		/// Name: SelectUsers
		/// Desc: Select by Login
		/// </summary>
 
		[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false)]
		public Smartest.ST_USERSDataTable SelectUsers(string USER_EMAIL, string USER_PASSWORD)
		{
			return this.Adapter.SelectUserByLogin(USER_EMAIL, USER_PASSWORD);
		}
 
		/// <summary>
		/// Function
		/// Name: DeleteUser
		/// Desc: Delete
		/// </summary>
 
		[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
		public bool DeleteUser(int USER_ID)
		{
			// Delete the record
			int rowsAffected = this.Adapter.Delete(USER_ID);
 
			// Return true if precisely one row was deleted, otherwise false
			return rowsAffected == 1;
		}
 
		/// <summary>
		/// Function
		/// Name: InsertUser
		/// Desc: Insert
		/// </summary>
 
		[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
		public bool InsertUser(	DateTime USER_CREATETIME,
								int USER_CREATEBY,
								DateTime USER_UPDATETIME,
								int USER_UPDATEBY,
								int USER_STATUS,
								string USER_NAME,
								string USER_DESC,
								int USER_COUNTRY_ID,
								int USER_CITY_ID,
								string USER_ADDRESS,
								string USER_ZIP,
								string USER_PHONE,
								string USER_MOBILE,
								string USER_FAX,
								string USER_EMAIL,
								string USER_PASSWORD,
								bool USER_ADMIN)
		{
			// Create a new row instance
			Smartest.ST_USERSDataTable Users = new Smartest.ST_USERSDataTable();
			Smartest.ST_USERSRow User = Users.NewST_USERSRow();
 
			// Fill the parameters
			User.USER_CREATETIME = USER_CREATETIME;
			User.USER_CREATEBY = USER_CREATEBY;
			User.USER_UPDATETIME = USER_UPDATETIME;
			User.USER_UPDATEBY = USER_UPDATEBY;
			User.USER_STATUS = USER_STATUS;
			User.USER_NAME = USER_NAME;
			User.USER_DESC = USER_DESC;
			User.USER_COUNTRY_ID = USER_COUNTRY_ID;
			User.USER_CITY_ID = USER_CITY_ID;
			User.USER_ADDRESS = USER_ADDRESS;
			User.USER_ZIP = USER_ZIP;
			User.USER_PHONE = USER_PHONE;
			User.USER_MOBILE = USER_MOBILE;
			User.USER_FAX = USER_FAX;
			User.USER_EMAIL = USER_EMAIL;
			User.USER_PASSWORD = USER_PASSWORD;
			User.USER_ADMIN = USER_ADMIN;
			
			// Insert the record
			Users.AddST_USERSRow(User);
			int rowsAffected = this.Adapter.Update(Users);
 
			// Return true if precisely one row was inserted, otherwise false
			return rowsAffected == 1;
		}
 
		/// <summary>
		/// Function
		/// Name: UpdateUser
		/// Desc: Update
		/// </summary>
 
		[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
		public bool UpdateUser( int USER_ID,
								DateTime USER_UPDATETIME,
								int USER_UPDATEBY,
								int USER_STATUS,
								string USER_NAME,
								string USER_DESC,
								int USER_COUNTRY_ID,
								int USER_CITY_ID,
								string USER_ADDRESS,
								string USER_ZIP,
								string USER_PHONE,
								string USER_MOBILE,
								string USER_FAX,
								string USER_EMAIL,
								string USER_PASSWORD,
								bool USER_ADMIN)
		{
			// Check if exist by id
			Smartest.ST_USERSDataTable Users = this.Adapter.SelectUserByID(USER_ID);
			if (Users.Count == 0)
				return false;
 
			// Create the row instance
			Smartest.ST_USERSRow User = Users[0];
 
			// Fill the parameters
			User.USER_UPDATETIME = USER_UPDATETIME;
			User.USER_UPDATEBY = USER_UPDATEBY;
			User.USER_STATUS = USER_STATUS;
			User.USER_NAME = USER_NAME;
			User.USER_DESC = USER_DESC;
			User.USER_COUNTRY_ID = USER_COUNTRY_ID;
			User.USER_CITY_ID = USER_CITY_ID;
			User.USER_ADDRESS = USER_ADDRESS;
			User.USER_ZIP = USER_ZIP;
			User.USER_PHONE = USER_PHONE;
			User.USER_MOBILE = USER_MOBILE;
			User.USER_FAX = USER_FAX;
			User.USER_EMAIL = USER_EMAIL;
			User.USER_PASSWORD = USER_PASSWORD;
			User.USER_ADMIN = USER_ADMIN;
 
			// Update the record
			int rowsAffected = this.Adapter.Update(User);
 
			// Return true if precisely one row was updated, otherwise false
			return rowsAffected == 1;
		}
	}
}

           
         

Start your free trial to view this solution

Question Stats

Zone: Programming

Question Asked By: sagir

Solution Provided By: PlatoConsultant

Participating Experts: 3

Solution Grade: A

Translate:

Loading Advertisement...

20080236-EE-VQP-29 / EE_QW_2_20070628