1 Again About Views.
How about such problems? Are these bugs or no ? When are you going to solve problem
1.1 Tool ignore Views with such code:
SELECT dbo.V_LDS3_Expositor.Id_Ekspositor, dbo.V_LDS3_Expositor.ID_Construction, dbo.V_LDS3_ConstructionTypSpec.Construction, dbo.V_LDS3_ConstructionTypSpec.PanelCount FROM dbo.V_LDS3_Expositor INNER
JOIN dbo.V_LDS3_ConstructionTypSpec ON dbo.V_LDS3_Expositor.ID_Construction = dbo.V_LDS3_ConstructionTypSpec.ID_Construction
-- here I use another view inside first
1.2 Tool ignore Views with such code:
SELECT TOP (100) PERCENT dbo.crs_Route.ID_Route, dbo.crs_Route.Dt, dbo.crs_Route.Flag_Approved, dbo.crs_Route.Id_TrRepres, dbo.crs_TrRepres.Description AS TrRepresName, dbo.crs_Route.Description
AS RouteDescription, ISNULL(dbo.V_LDS2_RouteMeetingsCount.MeetingCount, 0) AS MeetingCount, dbo.GetFriendlyDate(dbo.crs_Route.Dt, 1, 1, 1, 0, 'ru') AS FriendlyDate,
'Неделя ' + CAST(DATEPART(ww, dbo.crs_Route.Dt) AS varchar) AS WeekFROM dbo.crs_TrRepres INNER JOIN dbo.crs_Route ON dbo.crs_TrRepres.Id_TrRepres = dbo.crs_Route.Id_TrRepres
LEFT OUTER JOIN dbo.V_LDS2_RouteMeetingsCount ON dbo.crs_Route.ID_Route = dbo.V_LDS2_RouteMeetingsCount.ID_RouteORDER BY dbo.crs_Route.Dt
-- here i Use ScalarFunction inside sp
2 About Silverlight i'd want tell next:
I've found that i can't use DTO project for my Silverlight 3 purpose, because Silverlight has no [Serializable()] attribute realization.But Silverlight have XMLSerialization instead of [Serializable()] .Of courcse it's not a
problem to modify template for custom usings.
So I suggest you to include new official DTO template with support for silverlight. Code template you can use from other tool that generates classes from xsd entities - XSD2Code. Codeplex host this project too. This tool has serialization support in
3 How about the same template generationg options( For example Use Serializable / use LoadFile/ use CustomCollection ) as XSD2Code give you before generate code template - so we need'not to make another custom generator.