public StringBuilder BuildSelectAllByForeignKeyInterface(DataStructure entity) { StringBuilder res = new StringBuilder(); foreach (Key k in entity.GetForeignKeys()) { res.AppendLine($"IEnumerable<{entity.ClrName}> GetAllBy{k.ClrName}({k.GetClrType()} {k.ClrName});"); } return res; }
public StringBuilder BuildUpdatePublic(DataStructure entity) { StringBuilder res = new StringBuilder(); res.AppendLine($"public void Update({entity.ClrName} entity){{"); res.AppendLine("IStatementBuilder statement = _statementBuilderFactory.Build(QueryType.Update);"); res.AppendLine("BuildUpdateQuery(ref statement, entity);"); res.AppendLine("Execute(statement);"); res.AppendLine("}"); return res; }
public StringBuilder BuildCountAllPrivate(DataStructure entity) { StringBuilder res = new StringBuilder(); res.AppendLine($"private void BuildCountQuery(ref IStatementBuilder sb){{"); res.AppendLine($"sb.Append(\"select count(1) from {entity.Name}\");"); res.AppendLine("}"); return res; }
public StringBuilder BuildDeleteAllPublic(DataStructure entity) { StringBuilder res = new StringBuilder(); res.AppendLine($"public void DeleteAll(){{"); res.AppendLine($"IStatementBuilder statement = _statementBuilderFactory.Build(QueryType.Delete);"); res.AppendLine($"BuildDeleteAllQuery(ref statement);"); res.AppendLine($"Execute(statement);"); res.AppendLine("}"); return res; }
public StringBuilder BuildDeleteByForeignKeyInterface(DataStructure entity) { StringBuilder res = new StringBuilder(); foreach (Key k in entity.GetForeignKeys()) { res.AppendLine($"void DeleteAllBy{k.ClrName}({k.GetClrType()} {k.Name});"); } return res; }
public StringBuilder BuildCountAllPublic(DataStructure entity) { StringBuilder res = new StringBuilder(); res.AppendLine($"public int Count(){{"); res.AppendLine($"IStatementBuilder statement = _statementBuilderFactory.Build(QueryType.SelectSingleRow);"); res.AppendLine($"BuildCountQuery(ref statement);"); res.AppendLine($"IResult query = Execute(statement);"); res.AppendLine($"int res = query.ValueAsInt();"); res.AppendLine($"return res;"); res.AppendLine("}"); return res; }
public StringBuilder BuildDeleteAllPrivate(DataStructure entity) { StringBuilder res = new StringBuilder(); res.AppendLine("private void BuildDeleteAllQuery(ref IStatementBuilder res)"); res.AppendLine("{"); res.AppendLine($"res.Append(\"DELETE FROM [dbo].[{entity.Name}] \");"); res.AppendLine("}"); return res; }
public StringBuilder BuildDeleteByForeignKeyPrivate(DataStructure entity) { StringBuilder res = new StringBuilder(); foreach (Key fk in entity.GetForeignKeys()) { res.AppendLine($"private void BuildDeleteAllBy{fk.ClrName}Query(ref IStatementBuilder sb,{fk.GetClrType()} {fk.ClrName}){{"); res.AppendLine($"sb.Append(\"delete from {entity.Name} where {fk.Name} = @{fk.Name}\");"); res.AppendLine($"sb.AddParameter(\"{fk.Name}\", {fk.ClrName},DbType.{fk.GetDbType()});"); res.AppendLine("}"); } return res; }
public StringBuilder BuildDeleteByForeignKeyPublic(DataStructure entity) { StringBuilder res = new StringBuilder(); foreach (Key fk in entity.GetForeignKeys()) { res.AppendLine($"public void DeleteAllBy{fk.ClrName}({fk.GetClrType()} {fk.ClrName}){{"); res.AppendLine("IStatementBuilder statement = _statementBuilderFactory.Build(QueryType.Delete);"); res.AppendLine($"BuildDeleteAllBy{fk.ClrName}Query(ref statement, {fk.ClrName});"); res.AppendLine("Execute(statement);"); res.AppendLine("}"); } return res; }
public StringBuilder BuildInsertPublic(DataStructure entity) { StringBuilder res = new StringBuilder(); res.AppendLine($"public {entity.ClrName} Insert({entity.ClrName} item){{"); res.AppendLine("IStatementBuilder statement = _statementBuilderFactory.Build(QueryType.Insert);"); res.AppendLine($"BuildInsert{entity.ClrName}Query(ref statement, item);"); res.AppendLine("IResult query = Execute(statement);"); if (entity.Keys.Any(pK => pK.IsIdentity)) { res.AppendLine($"item.{entity.Keys.Single(pK => pK.IsIdentity).ClrName}=query.ValueAsInt();"); } res.AppendLine("return item;"); res.AppendLine("}"); return res; }
public StringBuilder BuildUpdatePrivate(DataStructure entity) { StringBuilder sb = new StringBuilder(); var primaryKeys = entity.Keys.Where(pK => pK.IsPrimary); var otherKeys = entity.Keys.Where(pK => !pK.IsPrimary); sb.AppendLine($"private void BuildUpdateQuery(ref IStatementBuilder sb, {entity.ClrName} pItem)"); sb.AppendLine("{"); sb.AppendLine($"sb.Append(\"UPDATE [dbo].[{entity.Name}] \");"); sb.AppendLine("sb.Append(\"SET\");"); foreach (var k in otherKeys) { if (k.Name == otherKeys.First().Name) { sb.AppendLine($"sb.Append(\"[{ k.Name}] = @{ k.Name} \");"); } else { sb.AppendLine($"sb.Append(\",[{ k.Name}] = @{ k.Name} \");"); } } foreach (var k in primaryKeys) { if (k.Name == primaryKeys.First().Name) { sb.AppendLine($"sb.Append(\"WHERE [{ k.Name}] = @{ k.Name} \");"); } else { sb.AppendLine($"sb.Append(\"AND [{ k.Name}] = @{ k.Name} \");"); } } foreach (var k in otherKeys) { sb.AppendLine($"sb.AddParameter(\"{k.Name}\", pItem.{k.ClrName},DbType.{k.GetDbType()});"); } foreach (var k in primaryKeys) { sb.AppendLine($"sb.AddParameter(\"{ k.Name}\", pItem.{ k.ClrName},DbType.{k.GetDbType()});"); } sb.AppendLine("}"); return sb; }
public virtual void GenerateEntity(DataStructure structure) { try { string template = ReadTemplate("EntityTemplate.txt"); string entityNamespace = _parameterReaderService.Get<string>("namespace", "entity"); string filePath = Path.Combine(_parameterReaderService.Get<string>("output", "baseDirectory"), _parameterReaderService.Get<string>("output", "entityDirectory")); template = template.Replace("#NAMESPACE#", entityNamespace); template = template.Replace("#ENTITY#", structure.ClrName); template = template.Replace("#KEYS#", string.Join(Environment.NewLine + Environment.NewLine, structure.Keys.Select(GenerateKey))); WriteFile(filePath, $"{structure.ClrName}.generated.cs", template); } catch (Exception ex) { _logger.Exception(ex); } }
public StringBuilder BuildInsertPrivate(DataStructure entity) { StringBuilder sb = new StringBuilder(); var keysToInsert = entity.Keys.Where(pK => !pK.IsIdentity); sb.AppendLine($"private void BuildInsert{entity.ClrName}Query(ref IStatementBuilder sb, {entity.ClrName} pItem)"); sb.AppendLine("{"); sb.AppendLine($"sb.Append(\"INSERT INTO [dbo].[{keysToInsert.Select(pk => pk.Name).Aggregate((pA, pB) => pA + "], [" + pB)}] ([{ entity.Name}])\"); "); sb.AppendLine("sb.Append(\"VALUES( \");"); foreach (var k in keysToInsert) { string sep; if (keysToInsert.Last().Name == k.Name) { sep = ");"; } else { sep = ","; } sb.AppendLine($"sb.Append(\"@{k.Name}{sep}\");"); sb.AppendLine(); } if (entity.Keys.Any(pK => pK.IsIdentity)) { sb.AppendLine("sb.Append(\"SELECT @@IDENTITY;\");"); } foreach (var k in keysToInsert) { sb.AppendLine($"sb.AddParameter(\"{k.Name}\", pItem.{k.ClrName},DbType.{k.GetDbType()});"); sb.AppendLine(); } sb.AppendLine("}"); sb.AppendLine(); return sb; }
public StringBuilder BuildDeleteAllInterface(DataStructure entity) { StringBuilder res = new StringBuilder(); res.AppendLine($"void DeleteAll();"); return res; }
public StringBuilder BuildInsertInterface(DataStructure entity) { StringBuilder res = new StringBuilder(); res.AppendLine($"{entity.ClrName} Insert({entity.ClrName} {entity.Name});"); return res; }
public StringBuilder BuildSelectAllWithPaginationPublic(DataStructure entity) { StringBuilder res = new StringBuilder(); if (entity.GetPrimaryKeys().Any()) { res.AppendLine($"public IPagedEnumerable<{entity.ClrName}> GetAllPaged(int pageSize ,int page){{"); res.AppendLine($"IStatementBuilder statement = _statementBuilderFactory.Build(QueryType.SelectMultipleRows);"); res.AppendLine($"BuildGetAllPagedQuery(ref statement,pageSize,page);"); res.AppendLine($"IResult query = Execute(statement);"); res.AppendLine($"IPagedEnumerable<{entity.ClrName}> res = new PagedEnumerable<{entity.ClrName}>(query.ToList<{entity.ClrName}>(),page,pageSize,0);"); res.AppendLine($"return res;"); res.AppendLine("}"); } return res; }
public StringBuilder BuildDeleteByIdInterface(DataStructure entity) { StringBuilder res = new StringBuilder(); if (entity.GetPrimaryKeys().Any()) { string parameters = entity.GetPrimaryKeys().Select(pk => $"{pk.GetClrType()} {pk.ClrName}").Aggregate((a, b) => a + ", " + b); res.AppendLine($"void Delete({parameters});"); } return res; }
public StringBuilder BuildCountAllInterface(DataStructure entity) { StringBuilder res = new StringBuilder(); res.AppendLine($"int Count();"); return res; }
public StringBuilder BuildSelectSingleByForeignKeyPublic(DataStructure entity) { StringBuilder res = new StringBuilder(); foreach (Key fk in entity.GetForeignKeys()) { res.AppendLine($"public {entity.ClrName} GetBy{fk.ClrName}({fk.GetClrType()} {fk.ClrName}){{"); res.AppendLine($"IStatementBuilder statement = _statementBuilderFactory.Build(QueryType.SelectSingleRow);"); res.AppendLine($"BuildGetBy{fk.ClrName}Query(ref statement, {fk.ClrName});"); res.AppendLine($"IResult query = Execute(statement);"); res.AppendLine($"{entity.ClrName} res = query.SingleOrDefault<{entity.ClrName}>();"); res.AppendLine($"return res;"); res.AppendLine("}"); } return res; }
public StringBuilder BuildSelectSingleByIdPublic(DataStructure entity) { StringBuilder res = new StringBuilder(); if (entity.GetPrimaryKeys().Any()) { string protoParameters = entity.GetPrimaryKeys().Select(pk => $"{pk.GetClrType()} {pk.ClrName}").Aggregate((a, b) => a + ", " + b); res.AppendLine($"public {entity.ClrName} Get({protoParameters}){{"); res.AppendLine($"IStatementBuilder statement = _statementBuilderFactory.Build(QueryType.SelectSingleRow);"); string parameters = entity.GetPrimaryKeys().Select(pk => $"{pk.ClrName}").Aggregate((a, b) => a + ", " + b); res.AppendLine($"BuildGetQuery(ref statement, {parameters});"); res.AppendLine($"IResult query = Execute(statement);"); res.AppendLine($"{entity.ClrName} res = query.SingleOrDefault<{entity.ClrName}>();"); res.AppendLine($"return res;"); res.AppendLine("}"); } return res; }
public StringBuilder BuildSelectSingleByIdPrivate(DataStructure entity) { StringBuilder res = new StringBuilder(); if (entity.GetPrimaryKeys().Any()) { string protoParameters = entity.GetPrimaryKeys().Select(pk => $"{pk.GetClrType()} {pk.ClrName}").Aggregate((a, b) => a + ", " + b); string parameters = entity.GetPrimaryKeys().Select(pk => $"{pk.ClrName}").Aggregate((a, b) => a + ", " + b); res.AppendLine($"private void BuildGetQuery(ref IStatementBuilder sb,{protoParameters}){{"); res.AppendLine($"sb.Append(\"select top 1 * from {entity.Name} where \");"); foreach (var k in entity.GetPrimaryKeys()) { if (k.Name == entity.GetPrimaryKeys().First().Name) { res.AppendLine($"sb.Append(\"WHERE [{k.Name}] = @{k.Name} \");"); } else { res.AppendLine($"sb.Append(\"AND [{k.Name}] = @{k.Name} \");"); } } foreach (var k in entity.GetPrimaryKeys()) { res.AppendLine($"sb.AddParameter(\"{k.Name}\", {k.ClrName},DbType.{k.GetDbType()});"); } res.AppendLine("}"); } return res; }
public StringBuilder BuildDeleteByIdsPublic(DataStructure entity) { StringBuilder res = new StringBuilder(); if (entity.GetPrimaryKeys().Any()) { string parameter = entity.GetPrimaryKeys().Select(pk => $"IEnumerable<{pk.GetClrType()}> {pk.ClrName}").Single(); res.AppendLine($"public void DeleteAllByIds({parameter}){{"); res.AppendLine("IStatementBuilder statement = _statementBuilderFactory.Build(QueryType.Delete);"); string parameters = entity.GetPrimaryKeys().Select(pk => $"{pk.ClrName}").Aggregate((a, b) => a + ", " + b); res.AppendLine($"BuildDeleteAllByIdsQuery(ref statement,{parameters});"); res.AppendLine("Execute(statement);"); res.AppendLine("}"); } return res; }
public StringBuilder BuildSelectAllWithPaginationPrivate(DataStructure entity) { StringBuilder res = new StringBuilder(); if (entity.GetPrimaryKeys().Any()) { string primaryKeys = entity.GetPrimaryKeys().Select(pk => $"{pk.Name}").Aggregate((a, b) => a + ", " + b); res.AppendLine($"private void BuildGetAllPagedQuery(ref IStatementBuilder sb, int pageSize ,int page){{"); res.AppendLine($"sb.Append(\";With SQLPaging As(\");"); res.AppendLine($"sb.Append(\"Select Top(@pageSize * @page) ROW_NUMBER() OVER(ORDER BY {primaryKeys} asc)\");"); res.AppendLine($"sb.Append(\"as resultNum, *\");"); res.AppendLine($"sb.Append(\"FROM {entity.Name} )\");"); res.AppendLine($"sb.Append(\"select * from SQLPaging with (nolock) where resultNum > ((@page - 1) * @pageSize)\");"); res.AppendLine($"sb.AddParameter(\"page\", page,DbType.Int32);"); res.AppendLine($"sb.AddParameter(\"pageSize\",pageSize,DbType.Int32);"); res.AppendLine("}"); } return res; }
private void GenerateProviderImpl(DataStructure table) { try { string template = ReadTemplate("ProviderImplTemplate.txt"); string entityNamespace = _parameterReaderService.Get<string>("namespace", "entity"); string providerImplNamespace = _parameterReaderService.Get<string>("namespace", "provider", "impl"); string providerInterfaceNamespace = _parameterReaderService.Get<string>("namespace", "provider", "interface"); string baseClassNamespace = _parameterReaderService.Get<string>("provider", "baseClass", "namespace"); string baseClassName = _parameterReaderService.Get<string>("provider", "baseClass", "name"); string filePath = Path.Combine(_parameterReaderService.Get<string>("output", "baseDirectory"), _parameterReaderService.Get<string>("output", "providerDirectory", "impl")); template = template.Replace("#NAMESPACE#", providerImplNamespace); template = template.Replace("#INTERFACE-NAMESPACE#", providerInterfaceNamespace); template = template.Replace("#ENTITY-NAMESPACE#", entityNamespace); template = template.Replace("#ENTITY#", table.Name); template = template.Replace("#BASE-CLASS-NAMESPACE#", baseClassNamespace); template = template.Replace("#BASE-CLASS#", baseClassName); StringBuilder publicMethods = new StringBuilder(); publicMethods.AppendLine(_selectQueryGenerator.BuildSelectSingleByIdPublic(table).ToString()); publicMethods.AppendLine(_selectQueryGenerator.BuildCountAllPublic(table).ToString()); publicMethods.AppendLine(_selectQueryGenerator.BuildSelectAllByForeignKeyPublic(table).ToString()); publicMethods.AppendLine(_selectQueryGenerator.BuildSelectAllByForeignKeyWithPaginationPublic(table).ToString()); publicMethods.AppendLine(_selectQueryGenerator.BuildSelectAllByIdsPublic(table).ToString()); publicMethods.AppendLine(_selectQueryGenerator.BuildSelectAllByIdsWithPaginationPublic(table).ToString()); publicMethods.AppendLine(_selectQueryGenerator.BuildSelectAllPublic(table).ToString()); publicMethods.AppendLine(_selectQueryGenerator.BuildSelectAllWithPaginationPublic(table).ToString()); publicMethods.AppendLine(_selectQueryGenerator.BuildSelectSingleByForeignKeyPublic(table).ToString()); publicMethods.AppendLine(_selectQueryGenerator.BuildAnyPublic(table).ToString()); if (table.Type == Entity.DataStructureType.Table) { publicMethods.AppendLine(_insertQueryGenerator.BuildInsertPublic(table).ToString()); publicMethods.AppendLine(_updateQueryGenerator.BuildUpdatePublic(table).ToString()); publicMethods.AppendLine(_deleteQueryGenerator.BuildDeleteAllPublic(table).ToString()); publicMethods.AppendLine(_deleteQueryGenerator.BuildDeleteByIdPublic(table).ToString()); publicMethods.AppendLine(_deleteQueryGenerator.BuildDeleteByForeignKeyPublic(table).ToString()); publicMethods.AppendLine(_deleteQueryGenerator.BuildDeleteByIdsPublic(table).ToString()); } template = template.Replace("#PUBLIC-METHODS#", publicMethods.ToString()); StringBuilder privateMethods = new StringBuilder(); privateMethods.AppendLine(_selectQueryGenerator.BuildSelectSingleByIdPrivate(table).ToString()); privateMethods.AppendLine(_selectQueryGenerator.BuildCountAllPrivate(table).ToString()); privateMethods.AppendLine(_selectQueryGenerator.BuildSelectAllByForeignKeyPrivate(table).ToString()); privateMethods.AppendLine(_selectQueryGenerator.BuildSelectAllByForeignKeyWithPaginationPrivate(table).ToString()); privateMethods.AppendLine(_selectQueryGenerator.BuildSelectAllByIdsPrivate(table).ToString()); privateMethods.AppendLine(_selectQueryGenerator.BuildSelectAllByIdsWithPaginationPrivate(table).ToString()); privateMethods.AppendLine(_selectQueryGenerator.BuildSelectAllPrivate(table).ToString()); privateMethods.AppendLine(_selectQueryGenerator.BuildSelectAllWithPaginationPrivate(table).ToString()); privateMethods.AppendLine(_selectQueryGenerator.BuildSelectSingleByForeignKeyPrivate(table).ToString()); privateMethods.AppendLine(_selectQueryGenerator.BuildAnyPrivate(table).ToString()); if (table.Type == Entity.DataStructureType.Table) { privateMethods.AppendLine(_insertQueryGenerator.BuildInsertPrivate(table).ToString()); privateMethods.AppendLine(_updateQueryGenerator.BuildUpdatePrivate(table).ToString()); privateMethods.AppendLine(_deleteQueryGenerator.BuildDeleteAllPrivate(table).ToString()); privateMethods.AppendLine(_deleteQueryGenerator.BuildDeleteByIdPrivate(table).ToString()); privateMethods.AppendLine(_deleteQueryGenerator.BuildDeleteByForeignKeyPrivate(table).ToString()); privateMethods.AppendLine(_deleteQueryGenerator.BuildDeleteByIdsPrivate(table).ToString()); } template = template.Replace("#PRIVATE-METHODS#", privateMethods.ToString()); WriteFile(filePath, $"{table.Name}Provider.generated.cs", template); } catch (Exception ex) { _logger.Exception(ex); } }
private void GenerateProviderInterface(DataStructure table) { try { string template = ReadTemplate("ProviderInterfaceTemplate.txt"); string entityNamespace = _parameterReaderService.Get<string>("namespace", "entity"); string providerNamespace = _parameterReaderService.Get<string>("namespace", "provider", "interface"); string filePath = Path.Combine(_parameterReaderService.Get<string>("output", "baseDirectory"), _parameterReaderService.Get<string>("output", "providerDirectory", "interface")); template = template.Replace("#NAMESPACE#", providerNamespace); template = template.Replace("#ENTITY-NAMESPACE#", entityNamespace); template = template.Replace("#ENTITY#", table.Name); StringBuilder methods = new StringBuilder(); methods.AppendLine(_selectQueryGenerator.BuildSelectSingleByIdInterface(table).ToString()); methods.AppendLine(_selectQueryGenerator.BuildCountAllInterface(table).ToString()); methods.AppendLine(_selectQueryGenerator.BuildSelectAllByForeignKeyInterface(table).ToString()); methods.AppendLine(_selectQueryGenerator.BuildSelectAllByForeignKeyWithPaginationInterface(table).ToString()); methods.AppendLine(_selectQueryGenerator.BuildSelectAllByIdsInterface(table).ToString()); methods.AppendLine(_selectQueryGenerator.BuildSelectAllByIdsWithPaginationInterface(table).ToString()); methods.AppendLine(_selectQueryGenerator.BuildSelectAllInterface(table).ToString()); methods.AppendLine(_selectQueryGenerator.BuildSelectAllWithPaginationInterface(table).ToString()); methods.AppendLine(_selectQueryGenerator.BuildSelectSingleByForeignKeyInterface(table).ToString()); methods.AppendLine(_selectQueryGenerator.BuildAnyInterface(table).ToString()); if (table.Type == Entity.DataStructureType.Table) { methods.AppendLine(_insertQueryGenerator.BuildInsertInterface(table).ToString()); methods.AppendLine(_updateQueryGenerator.BuildUpdateInterface(table).ToString()); methods.AppendLine(_deleteQueryGenerator.BuildDeleteAllInterface(table).ToString()); methods.AppendLine(_deleteQueryGenerator.BuildDeleteByIdInterface(table).ToString()); methods.AppendLine(_deleteQueryGenerator.BuildDeleteByForeignKeyInterface(table).ToString()); methods.AppendLine(_deleteQueryGenerator.BuildDeleteByIdsInterface(table).ToString()); } template = template.Replace("#METHODS#", methods.ToString()); WriteFile(filePath, $"I{table.Name}Provider.generated.cs", template); } catch (Exception ex) { _logger.Exception(ex); } }
public StringBuilder BuildUpdateInterface(DataStructure entity) { StringBuilder res = new StringBuilder(); res.AppendLine($"void Update({entity.ClrName} {entity.ClrName});"); return res; }
public void GenerateProvider(DataStructure table) { GenerateProviderInterface(table); GenerateProviderImpl(table); }
public StringBuilder BuildDeleteByIdsInterface(DataStructure entity) { StringBuilder res; if (entity.GetPrimaryKeys().Count() == 1) { string parameter = entity.GetPrimaryKeys().Select(pk => $"IEnumerable<{pk.GetClrType()}> {pk.ClrName}").Single(); res = new StringBuilder($"void DeleteAllByIds({parameter});"); } else { res = new StringBuilder(); } return res; }
public StringBuilder BuildDeleteByIdsPrivate(DataStructure entity) { StringBuilder res = new StringBuilder(); if (entity.GetPrimaryKeys().Any()) { string parameter = entity.GetPrimaryKeys().Select(pk => $"IEnumerable<{pk.GetClrType()}> {pk.ClrName}").Single(); res.AppendLine($"private void BuildDeleteAllByIdsQuery(ref IStatementBuilder sb,{parameter}){{"); res.AppendLine($"sb.Append(\"delete from {entity.Name} where \");"); foreach (var k in entity.GetPrimaryKeys()) { if (k.Name == entity.GetPrimaryKeys().First().Name) { res.AppendLine($"sb.Append(\"WHERE [{k.Name}] = @{k.Name} \");"); } else { res.AppendLine($"sb.Append(\"AND [{k.Name}] = @{k.Name} \");"); } } foreach (var k in entity.GetPrimaryKeys()) { res.AppendLine($"sb.AddParameter(\"{k.Name}\", {k.ClrName},DbType.{k.GetDbType()});"); } res.AppendLine("}"); } return res; }
public StringBuilder BuildSelectAllWithPaginationInterface(DataStructure entity) { StringBuilder res = new StringBuilder(); if (entity.GetPrimaryKeys().Any()) { res.AppendLine($"IPagedEnumerable<{entity.ClrName}> GetAllPaged(int pageSize ,int page);"); } return res; }