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
Just started a \'real world\' project using .NET MVC, Ninject, PetaPoco and plan to use the repository pattern.
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
In the example given on PetaPoco\'s web site, this is how to开发者_高级运维 decorate a class: [PetaPoco.TableName(\"articles\")]
What is the corr开发者_StackOverflow社区ect syntax for this query? var l=db.Fetch<article>(\"SELECT * FROM articles WHERE title LIKE \'%@0%\'\", \'something\');
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.
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
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
I have the following model and methods: [PetaPoco.TableName(\"TestStep\")] [PetaPoco.PrimaryKey(\"ID\")]
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)