spot7.org logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML Categories

PetaPoco - How to turn off auto increment?


I agree It is a really strange and confusing behavior because their API is not always using that attribute.

There are two ways to make it work.

One is by not using the attribute in your example and using the overloaded method with the autoIncrement parameter, and setting it to false. Here is a full example:

// Create a PetaPoco database object
var db = new PetaPoco.Database("ConnectionSt");

// Create an article
var a = new Article
{
    article_id = 152,
    title = "My new article",
    content = "PetaPoco was here",
    date_created = DateTime.UtcNow
};

// Insert it by turning off auto-increment
db.Insert("articles", "article_id", false, a);

The other is to use the insert method that takes an object as a parameter:

// Create an article
var a = new Articles
{
    article_id = 1111,
    title = "My new article",
    content = "PetaPoco was here",
    date_created = DateTime.UtcNow
};

// Insert it by using the insert method that will
use the attribute!
db.Insert(a);

The overload that takes an object as a parameter is the only one that uses the PrimaryKey attribute internally, and it should work like a charm in your scenario.


Categories : C#

Related to : PetaPoco - How to turn off auto increment?
Invalid model when using petapoco and editortemplates
In your Partial View your model is an IEnumerable, but later in your editor template you have only one object. Should be: @model IEnumerable<App.Models.AccountListViewModel> @foreach (var item in Model ) { Html.EditorFor(item) }

Categories : Asp Net Mvc
Increment localStorage value by one
You are trying to increment a string, and trying to setItem without giving a key name. That will not work. localStorage.setItem('attempts',parseInt(localStorage.getItem('attempts'))+1);

Categories : Javascript
Integer pre-increment error
++int_name produces the value 1 assuming that int_name was zero before. 1 *= 10 does not make sense. You cannot modify 1. In any case you should split that code into multiple statements. Even if this worked nobody would understand it.

Categories : C#
Auto-increment 5 numbers off?
Auto-increment doesn't mean use the next highest number in the table. There are a few reasons why the auto-increment number is non-contiguous. The auto-increment step may not be 1 The previous rows may have been deleted Transactions inserting into the table may have been rolled back A record may have updated the auto-increment column The auto-increment start index may have been changed by a DDL

Categories : PHP
Increment Of Variable in another way in c# win. form
After you edited your question, I think what you're after is this public int incrementNumber(string number) { var lastNumber = int.Parse(number.Last()); return (number.Length - 1) + ((lastNumber + 1) % 10).ToString(); } % 10 or Mod 10 takes the reminder of the number divided by 10. So if you pass in 9 it will increment to 10 then wrap around to 0. When you pass in 5 it will increment to

Categories : C#
Recently Add
Process MainWindowTitle not displaying for all running processes
SendGrid Tutorial resulting in Bad Request
Dropdown list from table in ASP NET MVC
Newtonsoft.JSON Serialization Array, Object, or Null
Using LINQ to select a byte array
How to stop scripting?
C# access to object property after json decode
How to kill instance of Word/Excel File in C#
Datatypes for MemoryStream.Capacity vs MemoryStream.Length
How to remove a selected row from a table when using KnockoutJS
SqlCommand returns null even tho there is data in the database
Replacing words in a body of text from array
C# dropping milliseconds from Java SOAP call
C# Deserialize list in JSON
Deserialize xml by linq, default with many elements
How to Access Grid View from hub section Data Template Windows phone 8.1 in C#
Input dialogue popup on mouse click
WPF: Binding to MainWindow Property SOLVED
Why is setting a field many times slower than getting a field?
Change multiple materials in one GameObject in Unity3D
.NET MVC error client side with custom validation attribute
Windows Search Service - text saved in ansi (codepage 1251) format - search for non-english symbols gives no result
String.Split - Omit empty array elements OR below a certain length
RequiredFieldValidator does not validate when ValidationGroup applied
Which WCF's extension point should be used for setting context for each operation?
Determine var type depending on ternary (?) Operator on int array
Resolving Windows phone 8.1 Compilation Error: GetENumerator
Specific Ordering of a List of Objects using LINQ
'string' does not contain a definition for 'Fill' and no extension method 'Fill' accepting a first argument of type 'string' could be found
how can ı pass data from serverside to clientside
© Copyright 2017 spot7.org Publishing Limited. All rights reserved.