1

our team is looking to use a code generation tool for the current sharepoint application we are working on. We want to be able to generate most of the stored procedures and business entities instead of having to write them from scratch. Any recommendation what is the best code generation tool to use with sharepoint projects. I am familiar with CodeSmith, but I wasn't sure if there are any better solutions out there for this.

Bekh
  • 219
  • 3
  • 5
  • 3
    Not sure if you've done a lot of SP development, but why would you be using stored procedures? (I assume you're speaking of using them to access content in the content DB, which is not supported by MS.) – Jason Watts Jun 18 '09 at 22:19
  • Describe your application more in detail please and how you and your users plan on using it within a SharePoint site. – Marc Jun 20 '09 at 06:30

2 Answers2

3

Code generation is not really necessary for SharePoint, all the code is generated in the SharePoint .NET Libraries.

The formulation of your question implies quite serious misunderstandings about SharePoint and it's use of databases.

Nat
  • 14,175
  • 5
  • 41
  • 64
  • I'm sorry may be my questions wasn't clear, but we need code generation for web parts that interact with an external database not the sharepoint one. I know the sharepoint database is only accessible through the sharpeoint libraries and we don't need code generation for that. – Bekh Jun 19 '09 at 03:57
  • that does make more sense. Coding webpart can be a pain. – Nat Jun 21 '09 at 23:35
  • In that case I would suggest that your question has little to do with SharePoint (you are really talking about accessing a database from ASP.NET) and you might get better responses by removing the SharePoint tags and references. – Ryan Jun 22 '09 at 12:07
1

If you want to talk to a custom database through a generated Data Access Layer, I would say go for the ADO.NET Entity Framework (works with VS2008 SP1 and .NET 3.5 SP1 only though. A custom solution would be LLBLGen Pro

Colin
  • 10,630
  • 28
  • 36