Hi I am sending to you this mail to inform about a new
site on programming,database resource.This site
contains information/articles/tutorials on c# and some
windows optimization tips and tricks.We have plans to
expand this site to more programming lan
guages and database systems/tools but at this time
only for c#.
You the readers/viewers are our valuable asset,and you
can contribute your articles/tutorials to this site we
really appreciate any type of help from developers all
over the world because you the developers helps us to
make this site available and keep running smoothly...
You can visit this site by clicking url
http://www.programmerkingdom.com/
Thanks....
Manzour Hassan
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
I dont get what you mean. If you set the properties in the web.config, ASP.NET 2.0 and membership do all the work for you. All you have to do is call Profile.LastName = Eric or whatever your property is. My syntax maybe off but the concept still exist. I dont know why you wuold need a class. If you want to have more control [ and searching] you can use the TableProfile Provider and generate yoru own classes from datasets. Either way, youre only 1 wizard away.
Essentially converts role table from a pure list to a b-tree allowing establishment of a role admin at any point in the structure who is responsible for their respective branch.
These admins, in turn, can delegate authority down the branch by connecting ids with admin rights (the IsAdmin flag) to a subordinate role.
IBM's RACF works similarly and allows you to make different folks responsible for different things. In the M$ world, the closest thing is probably an OU.
BTW, finally found a WROX book late yesterday http://www.amazon.com/gp/product/0764596985/104-0486025-2059911?v=glance&n=283155 that showed how to use the ProvidersHelper class to instantiate my custom provider and call it outside of the Membership and Roles classes. That seems
to be a reasonable solution, at least so far...
Eric Ramseur <ramseur@...> wrote:
Can you please explain what you mean by parent role? Do you mean you want a root role and sub roles? You can in affect have a parent super root role by just making calls to IF user is in role and checking if they are in your desired parent role. You can do all this through code instead of mucking the implementation of ASPNETDB. -- Eric Ramseur Microsoft.NET Consultant Rainbow Portal 2.0 Admin ------------------------ http://eramseur.blogspot.com | ASP.NET 2.0 Questions
My project was accepted at codeplex for the xml profile provider. If anyone has expertise in XQuery or SQL Server 2005 XML, please just ask if you want to contribute. My provider will store profile data [ address,name,etc] as XML in SQL Server 2005 only which will allow for a more flexible searchable profile.
Thx, tried that but how do you get a profile class generated based on the information added to web.config?
Not a good fit for the other two tables, unless I'm missing something...
Eric Ramseur <ramseur@...> wrote:
Why dont you just store teh first name , last name in the profile instead of trying to mess with ASPNETDB. This is the reason they created the ASPNETDB system so you dont have to modify it unless you really need a complex system. In the profile API, you can make a
profile property of first name and last name with 2 lines of code in the web.config.
OK, I've got the source code for the ASP 2.0 Providers and I'm trying to make a series of modifications.
I need to add extra fields to the membership and role records, specifically:
First/last name to the aspnet_membership table
Parent role to the aspnet_Roles table
RoleAdmin and a UserData field to the aspnet_UsersInRoles table
I'm looking for a strategy to get these values into
the CreateUser, CreateRole, and AddUserToRole methods. I realize that the prototypes for these methods in the Membership and Role classes can't be extended to include the additional parameters. And, these classes seem to wait to instantiate a new provider until I invoke the CreateUser and CreateRole methods.
What makes sense to me is to somehow instantiate the custom provider beforehand, set a couple of custom properties, and then let my modified methods pick them up when I invoke it via Membership/Roles.
I don't want to use personalization on the role records.
Can you please explain what you mean by parent role? Do you mean you want a root role and sub roles? You can in affect have a parent super root role by just making calls to IF user is in role and checking if they are in your desired parent role. You can do all this through code instead of mucking the implementation of ASPNETDB. -- Eric Ramseur Microsoft.NET Consultant Rainbow Portal 2.0 Admin ------------------------ http://eramseur.blogspot.com | ASP.NET
2.0 Questions
Why dont you just store teh first name , last name in the profile instead of trying to mess with ASPNETDB. This is the reason they created the ASPNETDB system so you dont have to modify it unless you really need a complex system. In the profile API, you can make a profile property of first name and last name with 2 lines of code in the web.config.
OK, I've got the source code for the ASP 2.0 Providers and I'm trying to make a series of modifications.
I need to add extra fields to the membership and role records, specifically:
First/last name to the aspnet_membership table
Parent role to the aspnet_Roles table
RoleAdmin and a UserData field to the aspnet_UsersInRoles table
I'm looking for a strategy to get these values into the CreateUser, CreateRole, and AddUserToRole methods. I realize that the prototypes for these methods in the Membership and Role classes can't be extended to include the additional parameters. And, these classes seem to wait to instantiate a new provider until I invoke the CreateUser and CreateRole methods.
What makes sense to me is to somehow instantiate the custom provider beforehand, set a
couple of custom properties, and then let my modified methods pick them up when I invoke it via Membership/Roles.
I don't want to use personalization on the role records.
OK, I've got the source code for the ASP 2.0 Providers and I'm trying to make a series of modifications.
I need to add extra fields to the membership and role records, specifically:
First/last name to the aspnet_membership table
Parent role to the aspnet_Roles table
RoleAdmin and a UserData field to the aspnet_UsersInRoles table
I'm looking for a strategy to get these values into the CreateUser, CreateRole, and AddUserToRole methods. I realize that the prototypes for these methods in the Membership and Role classes can't be extended to include the additional parameters. And, these classes seem to wait to instantiate a new provider until I invoke the CreateUser and CreateRole methods.
What makes sense to me is to somehow instantiate the custom provider beforehand, set a
couple of custom properties, and then let my modified methods pick them up when I invoke it via Membership/Roles.
I don't want to use personalization on the role records.
Hi everyone, I am trying to make an small uninstall program for my project. However, I dettach the database, clear the registers but I could not make an uninstall program that removes all the softaware after these steps. (detach and clear register)
Thanks,
Hi everyone, I am trying to make an small uninstall program for my project. However, I dettach the database, clear the registers but I could not make an uninstall program that removes all the softaware after these steps. (detach and clear register)
Thanks,
MS is finally understanding what we proffessionals need. Here is a new prototype that auto generates a pretty good data connected App. All you need is the LINQ assemblies installed on the machine running the generated applications. The generator is called BLINQ because its built upon the LINQ assembiles which allow for query C# structure.
I glad to see our membership is up to 40 now from the 15 members we had a couple of months ago. I am sorry not to give more discussions in this group as I am crazy busy. I am currently going after my MVP, guiding Rainbow Portal on 2.0 framework to dominate the open source market, creating new products on 2.0 with the crazy influx of new components, and trying to keep up with 4 blogs.
Anywho, I would love to have a conversation/discussion about .NET 2.0/red hat linux/ mysql. This IMO could be a strong force in the near feature. Ive only used linux/mysql when I did work for web hosting clients and would like to know more. I know mono 2.0 wont be out till Q3 2006 [ if they are lucky] but want to get a head start. If anyone knows about great free red hat linux enterprise resources, please shoot me an email.
Help? If anyone needs help with C# or .NET in general, please dont hesitate to ask. I have 3 email alerts and answer email faster than a cell phone. I am always interested in what real developers are doing and ways to make their lives easier. Its the reason why I work on rainbow for it allows you to plug web applications into a open source alternative [ like sharepoint].
Ajax? If anyone needs any ajax help, I can offer many solutions as I am a dev for Magic Ajax and am testing out atlas.
Blog Topics? Im always in need to find something to write about and Im only human when I run out of topics. If you see a reoccurring question on a forum or you personally want to figure something out, please ask the group and Ill post about it.
Dear Friends, VT Manpower Consultancy Services Pvt Ltd., is the leading Manpower provider for IT and ITES Companies in South India. We are providing a better customized solutions to our valuable clients.Our core activities includes 1. Providing Recruitment Services and 2. Contract Staffing
Now we are recruiting Entry level Technical Support Engineers For HP Global soft Limited
Call:9941311321
Benefits To Join in HP Global soft Limited :
1.Internal migration:After one year HP Technical Support Engineer to HP Software
Engineer internal migration is also there.
2.Salary: HP is one of the good salary package providers among Software Companies.
3.Other Benefits:They are providing more benefits to the employees when we are comparing to other companies.
Call:9941311321
Please Refer your Friends/colleagues also.
Eligibility: BE/B.TECH and Experienced Other graduates
Interview location will be in Chennai or Bangalore.
Job Location is Bangalore only.
If your interested Send your Profiles to vtmanpower.hp@... with the subject line of Opening For callcenters or walk in to our
office.
I agree, I think I don't really have any choice! Thanks for the help
and input!
--- In csharp2@yahoogroups.com, "Eric Ramseur" <ramseur@...> wrote:
>
> I think its best just to store DAL, BLL, and classes that are not
associated
> with pages [ as they will be in another assembly like you stated]
and
> precompile your site. Its the same affect that you are trying to
achieve
> and its a better modle. I think you discovered the reason why you
shouldnt
> put your page codebehinds in app_code.
>
> On 4/18/06, glabana2003 <glabana2003@...> wrote:
> >
> > Hi Eric,
> >
> > Thanks for the quick reply.
> >
> > Firstly the url of the MSDN article is at:
> >
> > http://msdn.microsoft.com/asp.net/default.aspx?pull=/library/en-
> > us/dnvs05/html/Internals.asp
> >
> > I understand the point you are making. However on this MSDN
article
> > they state that you can put your code behind partial classes in
the
> > App_code folder (Unless I am misunderstanding).
> >
> > I think that this is not true!
> >
> > The reason is that from my understanding is that the asp 2
> > compilation model now uses partial classes for both the aspx and
the
> > code behind and then at runtime combines the 2 partial classes
into
> > one class. This is better performing then asp 1.1. as before all
> > code behind classes were complied into an application DLL and
then a
> > temporary DLL was created for each aspx requested by the web
> > client.
> >
> > However all classes in the App_code folder are compiled into a
> > separate assembly and thus the aspx cannot be joined to the code
> > behind and hence my error message.
> >
> > I agree with your comments that we should precomplie web apps,
but I
> > would like to be able to add my code behind partial classes to
the
> > app_code folder as stated in the MSDN article.
> >
> > this is what they say:
> >
> > Full runtime compilation— At the other extreme of deployment
> > precompilation, ASP.NET 2.0 provides a new mechanism to compile
the
> > entire application at runtime. That is, you can put your
uncompiled
> > code-behind files and any other associated code in the new
\app_code
> > directory and let ASP.NET 2.0 create and maintain references to
the
> > assembly that will be generated from these files at runtime. This
> > option provides the greatest flexibility in terms of changing Web
> > site content at the cost of storing uncompiled code on the
server.
> >
> > Any thoughs / corrections will be welcomed.
> >
> > Cheers
> > Garry
> >
> >
> >
> > --- In csharp2@yahoogroups.com, "Eric Ramseur" <ramseur@> wrote:
> > >
> > > Code-behind classes are best reserved for in the application
> > directory as
> > > they get complied by ASP.NET and this could cause issues of a
> > compile
> > > twice. You should only put things like Business Language layer
> > classes or
> > > DAL classes in app_code. Other things are assemblyInfo.cs and
cs
> > files that
> > > are part of components and not code-behind for pages. If you
want
> > to trully
> > > compile your site, you should precompile it using Publish or
from
> > command
> > > prompt:
> > >
> > >
> > > Precompile apps by command prompt :
> > > http://eramseur.blogspot.com/2005/12/precompile-your-aspnet-
> > apps.html
> > >
> > > On 4/18/06, glabana2003 <glabana2003@> wrote:
> > > >
> > > > Hi,
> > > >
> > > > I get the following error when I put my code behind partial
class
> > > > (Myfile.aspx.cs) into the App-code folder:
> > > >
> > > > Error 106 The file '/MyApp/Logon.aspx.cs' is in the special
> > > > directory 'App_Code', which is not allowed.
> > > >
> > > > Is this true, are you not allowed to put code behind source
> > files in
> > > > to the App_code directory?.
> > > >
> > > > The following article from MSDN states otherwise under the
> > section
> > > >
> > > > Compilation in ASP.NET 2.0
> > > >
> > > > Can some please enlighten me
> > > >
> > > > Cheers
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------
> > > > YAHOO! GROUPS LINKS
> > > >
> > > >
> > > > - Visit your group "csharp2
> > <http://groups.yahoo.com/group/csharp2>"
> >
> > > > on the web.
> > > >
> > > > - To unsubscribe from this group, send an email to:
> > > > csharp2-unsubscribe@yahoogroups.com<csharp2-
> > unsubscribe@yahoogroups.com?subject=Unsubscribe>
> > > >
> > > > - Your use of Yahoo! Groups is subject to the Yahoo!
Terms of
> > > > Service <http://docs.yahoo.com/info/terms/>.
> > > >
> > > >
> > > > ------------------------------
> > > >
> > >
> > >
> > >
> > > --
> >
> > > Eric Ramseur
> > > Microsoft.NET Consultant
> > > ------------------------
> > > http://eramseur.blogspot.com | ASP.NET 2.0 Questions
> > >
> > > http://anant.us/blog | Anant ASP.NET 2.0 CMS | Portal Blogs [
free
> > blogs]
> > >
> > > http://url123.com/xe7pd | C# 2.0 Group on Yahoo!
> > >
> > > "Chance favors the prepared Mind"
> > >
> >
> >
> >
> >
> >
> > ------------------------------
> > YAHOO! GROUPS LINKS
> >
> >
> > - Visit your group "csharp2
<http://groups.yahoo.com/group/csharp2>"
> > on the web.
> >
> > - To unsubscribe from this group, send an email to:
> > csharp2-unsubscribe@yahoogroups.com<csharp2-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
> >
> > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service <http://docs.yahoo.com/info/terms/>.
> >
> >
> > ------------------------------
> >
>
>
>
> --
> Eric Ramseur
> Microsoft.NET Consultant
> ------------------------
> http://eramseur.blogspot.com | ASP.NET 2.0 Questions
>
> http://anant.us/blog | Anant ASP.NET 2.0 CMS | Portal Blogs [ free
blogs]
>
> http://url123.com/xe7pd | C# 2.0 Group on Yahoo!
>
> "Chance favors the prepared Mind"
>
I think its best just to store DAL, BLL, and classes that are not associated with pages [ as they will be in another assembly like you stated] and precompile your site. Its the same affect that you are trying to achieve and its a better modle. I think you discovered the reason why you shouldnt put your page codebehinds in app_code.
I understand the point you are making. However on this MSDN article
they state that you can put your code behind partial classes in the
App_code folder (Unless I am misunderstanding).
I think that this is not true!
The reason is that from my understanding is that the asp 2
compilation model now uses partial classes for both the aspx and the
code behind and then at runtime combines the 2 partial classes into
one class. This is better performing then asp 1.1. as before all
code behind classes were complied into an application DLL and then a
temporary DLL was created for each aspx requested by the web
client.
However all classes in the App_code folder are compiled into a
separate assembly and thus the aspx cannot be joined to the code
behind and hence my error message.
I agree with your comments that we should precomplie web apps, but I
would like to be able to add my code behind partial classes to the
app_code folder as stated in the MSDN article.
this is what they say:
Full runtime compilation— At the other extreme of deployment
precompilation, ASP.NET 2.0 provides a new mechanism to compile the
entire application at runtime. That is, you can put your uncompiled
code-behind files and any other associated code in the new \app_code
directory and let ASP.NET 2.0 create and maintain references to the
assembly that will be generated from these files at runtime. This
option provides the greatest flexibility in terms of changing Web
site content at the cost of storing uncompiled code on the server.
Any thoughs / corrections will be welcomed.
Cheers
Garry
--- In csharp2@yahoogroups.com, "Eric Ramseur" <ramseur@...> wrote:
>
> Code-behind classes are best reserved for in the application
directory as
> they get complied by ASP.NET and this could cause issues of a
compile
> twice. You should only put things like Business Language layer
classes or
> DAL classes in app_code. Other things are assemblyInfo.cs and cs
files that
> are part of components and not code-behind for pages. If you want
to trully
> compile your site, you should precompile it using Publish or from
command
> prompt:
>
>
> Precompile apps by command prompt :
> http://eramseur.blogspot.com/2005/12/precompile-your-aspnet-
apps.html
>
> On 4/18/06, glabana2003 <glabana2003@...> wrote:
> >
> > Hi,
> >
> > I get the following error when I put my code behind partial class
> > (Myfile.aspx.cs) into the App-code folder:
> >
> > Error 106 The file '/MyApp/Logon.aspx.cs' is in the special
> > directory 'App_Code', which is not allowed.
> >
> > Is this true, are you not allowed to put code behind source
files in
> > to the App_code directory?.
> >
> > The following article from MSDN states otherwise under the
section
> >
> > Compilation in ASP.NET 2.0
> >
> > Can some please enlighten me
> >
> > Cheers
> >
> >
> >
> >
> >
> >
> > ------------------------------
> > YAHOO! GROUPS LINKS
> >
> >
> > - Visit your group "csharp2
Hi Eric,
Thanks for the quick reply.
Firstly the url of the MSDN article is at:
http://msdn.microsoft.com/asp.net/default.aspx?pull=/library/en-
us/dnvs05/html/Internals.asp
I understand the point you are making. However on this MSDN article
they state that you can put your code behind partial classes in the
App_code folder (Unless I am misunderstanding).
I think that this is not true!
The reason is that from my understanding is that the asp 2
compilation model now uses partial classes for both the aspx and the
code behind and then at runtime combines the 2 partial classes into
one class. This is better performing then asp 1.1. as before all
code behind classes were complied into an application DLL and then a
temporary DLL was created for each aspx requested by the web
client.
However all classes in the App_code folder are compiled into a
separate assembly and thus the aspx cannot be joined to the code
behind and hence my error message.
I agree with your comments that we should precomplie web apps, but I
would like to be able to add my code behind partial classes to the
app_code folder as stated in the MSDN article.
this is what they say:
Full runtime compilation— At the other extreme of deployment
precompilation, ASP.NET 2.0 provides a new mechanism to compile the
entire application at runtime. That is, you can put your uncompiled
code-behind files and any other associated code in the new \app_code
directory and let ASP.NET 2.0 create and maintain references to the
assembly that will be generated from these files at runtime. This
option provides the greatest flexibility in terms of changing Web
site content at the cost of storing uncompiled code on the server.
Any thoughs / corrections will be welcomed.
Cheers
Garry
--- In csharp2@yahoogroups.com, "Eric Ramseur" <ramseur@...> wrote:
>
> Code-behind classes are best reserved for in the application
directory as
> they get complied by ASP.NET and this could cause issues of a
compile
> twice. You should only put things like Business Language layer
classes or
> DAL classes in app_code. Other things are assemblyInfo.cs and cs
files that
> are part of components and not code-behind for pages. If you want
to trully
> compile your site, you should precompile it using Publish or from
command
> prompt:
>
>
> Precompile apps by command prompt :
> http://eramseur.blogspot.com/2005/12/precompile-your-aspnet-
apps.html
>
> On 4/18/06, glabana2003 <glabana2003@...> wrote:
> >
> > Hi,
> >
> > I get the following error when I put my code behind partial class
> > (Myfile.aspx.cs) into the App-code folder:
> >
> > Error 106 The file '/MyApp/Logon.aspx.cs' is in the special
> > directory 'App_Code', which is not allowed.
> >
> > Is this true, are you not allowed to put code behind source
files in
> > to the App_code directory?.
> >
> > The following article from MSDN states otherwise under the
section
> >
> > Compilation in ASP.NET 2.0
> >
> > Can some please enlighten me
> >
> > Cheers
> >
> >
> >
> >
> >
> >
> > ------------------------------
> > YAHOO! GROUPS LINKS
> >
> >
> > - Visit your group "csharp2
<http://groups.yahoo.com/group/csharp2>"
> > on the web.
> >
> > - To unsubscribe from this group, send an email to:
> > csharp2-unsubscribe@yahoogroups.com<csharp2-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
> >
> > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service <http://docs.yahoo.com/info/terms/>.
> >
> >
> > ------------------------------
> >
>
>
>
> --
> Eric Ramseur
> Microsoft.NET Consultant
> ------------------------
> http://eramseur.blogspot.com | ASP.NET 2.0 Questions
>
> http://anant.us/blog | Anant ASP.NET 2.0 CMS | Portal Blogs [ free
blogs]
>
> http://url123.com/xe7pd | C# 2.0 Group on Yahoo!
>
> "Chance favors the prepared Mind"
>
Code-behind classes are best reserved for in the application directory as they get complied by ASP.NET and this could cause issues of a compile twice. You should only put things like Business Language layer classes or DAL classes in app_code. Other things are assemblyInfo.cs and cs files that are part of components and not code-behind for pages. If you want to trully compile your site, you should precompile it using Publish or from command prompt:
Hi,
I get the following error when I put my code behind partial class
(Myfile.aspx.cs) into the App-code folder:
Error 106 The file '/MyApp/Logon.aspx.cs' is in the special
directory 'App_Code', which is not allowed.
Is this true, are you not allowed to put code behind source files in
to the App_code directory?.
The following article from MSDN states otherwise under the section
Compilation in ASP.NET 2.0
Can some please enlighten me
Cheers
I started using nettiers but the problem is that
it does not support Oracle. Can anyone suggest me some tool which supports
oracle, mysql, & MS Sql. I would really thank you if you have any code
generators which would create a DAL for me.
What version of the .net framework are you
using? I suggest [ for any version] you look into some free code
generators. They can make your sprocs for you and install them into yoru
db as long as you have access. This can save you a lot of time and effort and
you can learn as you go. My fav generator is however not free but has a
30 day trial and def worth a look. It works with my microsoft dbs and
creates ALL Sprocs for insert,update,delete,select all , select by id. It
also can look at your DB structure and from your mappings see what extra sprocs
you need. So if you have two tables that ref each other then you will get
an extra Sproc to allow you to insert.
I started using nettiers but the problem is that
it does not support Oracle. Can anyone suggest me some tool which supports
oracle, mysql, & MS Sql. I would really thank you if you have any code
generators which would create a DAL for me.
What version of the .net framework are you
using? I suggest [ for any version] you look into some free code
generators. They can make your sprocs for you and install them into yoru
db as long as you have access. This can save you a lot of time and effort and
you can learn as you go. My fav generator is however not free but has a
30 day trial and def worth a look. It works with my microsoft dbs and
creates ALL Sprocs for insert,update,delete,select all , select by id. It
also can look at your DB structure and from your mappings see what extra sprocs
you need. So if you have two tables that ref each other then you will get
an extra Sproc to allow you to insert.
From:
csharp2@yahoogroups.com [mailto:csharp2@yahoogroups.com] On Behalf Of Eric Ramseur Sent: Monday, April 17, 2006 9:59
AM To: csharp2@yahoogroups.com Subject: Re: [csharp2] Need Inputs
on NHibernate.
I started using nettiers but the problem is that
it does not support Oracle. Can anyone suggest me some tool which supports
oracle, mysql, & MS Sql. I would really thank you if you have any code
generators which would create a DAL for me.
What version of the .net framework are you
using? I suggest [ for any version] you look into some free code
generators. They can make your sprocs for you and install them into yoru
db as long as you have access. This can save you a lot of time and effort and
you can learn as you go. My fav generator is however not free but has a
30 day trial and def worth a look. It works with my microsoft dbs and
creates ALL Sprocs for insert,update,delete,select all , select by id. It
also can look at your DB structure and from your mappings see what extra sprocs
you need. So if you have two tables that ref each other then you will get
an extra Sproc to allow you to insert.
I started using nettiers but the problem
is that it does not support Oracle. Can anyone suggest me some tool which
supports oracle, mysql, & MS Sql. I would really thank you if you have any
code generators which would create a DAL for me.
What version of the .net framework are you
using? I suggest [ for any version] you look into some free code
generators. They can make your sprocs for you and install them into yoru
db as long as you have access. This can save you a lot of time and effort and
you can learn as you go. My fav generator is however not free but has a
30 day trial and def worth a look. It works with my microsoft dbs and
creates ALL Sprocs for insert,update,delete,select all , select by id. It
also can look at your DB structure and from your mappings see what extra sprocs
you need. So if you have two tables that ref each other then you will get
an extra Sproc to allow you to insert.
I started using nettiers but the problem
is that it does not support Oracle. Can anyone suggest me some tool which
supports oracle, mysql, & MS Sql. I would really thank you if you have any
code generators which would create a DAL for me.
Thanx,
Purav Gandhi
From:
csharp2@yahoogroups.com [mailto:csharp2@yahoogroups.com] On Behalf Of Eric Ramseur Sent: Saturday, April 15, 2006 9:31
PM To: csharp2@yahoogroups.com Subject: Re: [csharp2] Need Inputs
on NHibernate.
Purav,
What version of the .net framework are you
using? I suggest [ for any version] you look into some free code
generators. They can make your sprocs for you and install them into yoru
db as long as you have access. This can save you a lot of time and effort and
you can learn as you go. My fav generator is however not free but has a
30 day trial and def worth a look. It works with my microsoft dbs and
creates ALL Sprocs for insert,update,delete,select all , select by id. It
also can look at your DB structure and from your mappings see what extra sprocs
you need. So if you have two tables that ref each other then you will get
an extra Sproc to allow you to insert.
What version of the .net framework are you using? I suggest [ for any version] you look into some free code generators. They can make your sprocs for you and install them into yoru db as long as you have access. This can save you a lot of time and effort and you can learn as you go. My fav generator is however not free but has a 30 day trial and def worth a look. It works with my microsoft dbs and creates ALL Sprocs for insert,update,delete,select all , select by id. It also can look at your DB structure and from your mappings see what extra sprocs you need. So if you have two tables that ref each other then you will get an extra Sproc to allow you to insert.
I have installed it and created the dll, but I don't get how to insert a particular row in the db. I have a table named Role, I get a method called CreateRole(int id, string s);
I try to insert and that is fine, but it does not reflect this in the db. Can you tell me please how to insert it into the db.
I am a newbie to .Net, I just wanted to know, what to use as a db layer. Using NHibernate is good or not, pros and cons for using it. Please let me know
I would take a look at IBATIS [ google search it] or Nhibernate. I would say the pros of IBATIS is that its not db dependent and can support any feature the db currently has. It also plan to use everything nhibernate uses. It also uses nhibernate to store somethings [ they are currently testing things]. All you have to do is write raw SQL or use SPROCS and you can support any db through XML files.
Nhib is more supported and has a bigger community that IBATIS but doesnt make it better. Its more the .NET approach to dbs and has some db reliant stuff. Take for example the xml node type. Nhib would have to make something special for storing in xml node type in 2005 but IBASTIS wouldnt :).
Personally, if you are starting out to make a dal layer...I wouldnt start with object persistance. I would start with the free Micfosot Enterprise libraries. They get the job done and take 4 lines of code to do pretty much most things. In pre beta of .net you had to write pure ADO.NET code to do anything and look how far weve come . [ of course im 24 and dont about the old old days but still :)]
I am a newbie to .Net, I just wanted to know, what to use as a db layer. Using NHibernate is good or not, pros and cons for using it. Please let me know
I have installed it and created the dll,
but I don’t get how to insert a particular row in the db. I have a table named
Role, I get a method called CreateRole(int id, string s);
I try to insert and that is fine, but it
does not reflect this in the db. Can you tell me please how to insert it into
the db.
Regards,
Purav Gandhi
From: csharp2@yahoogroups.com
[mailto:csharp2@yahoogroups.com] On Behalf Of
Mohamed A. Meligy Sent: Saturday, April 15, 2006
4:52 PM To: csharp2@yahoogroups.com Cc:
Visual_Studio_Dot_Net@yahoogroups.com; Microsofts_C_Sharp@yahoogroups.com Subject: Re: [csharp2] Need Inputs
on NHibernate.
I
am a newbie to .Net, I just wanted to know, what to use as a db layer. Using
NHibernate is good or not, pros and cons for using it. Please let me know