Hi,

I have a VS2005 solution and I need to generate namespace and project file (*.csproj) in below format

For DBGeneric project: Namespace = Company.ProductName.BLL.DTO ProjectName(assembly) = Company.ProductName.BLL.DTO(.dll)

Namespace for DBSpecific (SQL2005) project: Namespace = Company.ProductName.DAL.SQLServer ProjectName(assembly) = Company.ProductName.DAL.SQLServer(.dll)

How can I do this? I have played around the project properties and also SD.Tasks.Adapter.VsNetDbGenericProjectFileCreator and SD.Tasks.Adapter.VsNetDbSpecificProjectFileCreator but not able to do it.

Thanks in advance.

Regards

Kaksss

For DBGeneric project: Namespace = Company.ProductName.BLL.DTO ProjectName(assembly) = Company.ProductName.BLL.DTO(.dll)

Namespace for DBSpecific (SQL2005) project: Namespace = Company.ProductName.DAL.SQLServer ProjectName(assembly) = Company.ProductName.DAL.SQLServer(.dll)

For the ProjectName and hence the assembly, please set the following in the In the Designer -> ProjectProperties: **AdapterDbGenericProjectFileSuffix** = .BLL.DTO (you won't need this step, as changing the root namespace afterwards will affect the projectName/assembly) AdapterDbSpecificProjectFileSuffix = .DAL.SQLServer

For the DBSpecific Namespace, please set the following in the In the Designer -> ProjectProperties: AdapterDbSpecificNamespaceSuffix = DAL.SQLServer

And for the DBGeneric Namespace, in the Code Generation Window: 1- please go to the Task queue to execute tab 2- From the Run queue tree, please select the SD.Tasks.Adapter.DatabaseGeneric task Group. 3- Then down the window you will find a text box labled: Additional root namespace 4- Insert BLL.DTO in the text box. 5- Then generate the code, you will be asked to save the modified preset in order not to lose your changes for future code generations.