petapoco_开发者

Petapoco deleting datas while having one to many relations?

In my project we are using petapoco as our ORM for data access. But i face some difficulties while deleting datas which have one to many relations. I have two tables named user and group. Here one use[详细]

2023-04-12 07:24 分类：问答

Implementing Repository pattern with PetaPoco

Just started a \'real world\' project using .NET MVC, Ninject, PetaPoco and plan to use the repository pattern.[详细]

2023-04-03 16:07 分类：问答

Invalid cast exception when trying to map from int? to enum?

I have a senario where a user wants to select his gender which is not a mandatory field. Here in my ui the gender is listed in dropdownlist which has two options Male and Female and has a optional lab[详细]

2023-04-02 04:35 分类：问答

In PetaPoco, how to decorate a table that has multi-columns primary keys

In the example given on PetaPoco\'s web site, this is how to开发者_高级运维 decorate a class: [PetaPoco.TableName(\"articles\")][详细]

2023-04-02 01:14 分类：问答

PetaPoco: How to use the SQL Like keyword ( WHERE Name LIKE '%@0%')

What is the corr开发者_StackOverflow社区ect syntax for this query? var l=db.Fetch<article>(\"SELECT * FROM articles WHERE title LIKE \'%@0%\'\", \'something\');[详细]

2023-04-01 11:12 分类：问答

petapoco as abstractDao or BaseRepository

I am using petaPoco for the first time and i am trying to create some base class that will be an abstractDao class with eliminate the use of sql text for the excellent petaPoco code.[详细]

2023-03-31 13:15 分类：问答

PetaPoco to return self-referencing hierarchy

How would one write a query/method to retur开发者_高级运维n a POCO that is from a self-referencing database as shown in this questionFirstly you would map it a flat class. eg. db.Fetch<CategoryDb&g[详细]

2023-03-30 22:31 分类：问答

Have I misunderstood the PetaPoco.IgnoreAttribute?

I have a table开发者_JAVA技巧 containing service announcements. For this table I have a 1:1 POCO - except that it contains one extra field. In my query this is the joined in username of the author, th[详细]

2023-03-30 20:35 分类：问答

PetaPoco returning incorrect ID

I have the following model and methods: [PetaPoco.TableName(\"TestStep\")] [PetaPoco.PrimaryKey(\"ID\")][详细]

2023-03-30 04:39 分类：问答

How can integrate MVCMiniProfiler with PetaPoco without changing the sources

I\'m trying to get MVCMiniProfiler to work with PetaPoco I\'m trying to set the connection in the creation of the PetaPoco DB, but run into problems (connectionClosed)[详细]

2023-03-29 14:59 分类：问答