CODEWITHSUNDEEP
c#databaselinqdesktop-application
William Huang
William Huang

Reputation: 1

C# linq with server based database

I have problem with id Char(5) as a primary key, where the project need me to make the id with some combination of number and character. example P0001, when new data's inserted, the PK of the new data is P0002 and soon.

Can someone help me with the code? I know about the logic, but I don't know how to get the data from database using linq.

context = new CarRentalLinqDataContext(); 
Car car = new Car(); 
car.carName = textBox_CarName.Text; 
int year = Int32.Parse(textBox_CarYear.Text); 
car.carYear = year; 
var id = context.Cars.Max(x => car.car_id); 
id = id.Substring(id.LastIndexOf(car.car_id)); 
int i = Convert.ToInt32(id); i += 1; 
string Code = "C000" + i.ToString(); 
car.car_id = Code; context.Cars.InsertOnSubmit(car); 
context.SubmitChanges();

Upvotes: 0

Views: 77

Answers (1)

vishwarajanand
vishwarajanand

Reputation: 1071

Looks like you have a problem in creating a new id in the given table. You may do following:

1: Since, primary keys are already known combination of chars and numbers, you can do lexical sorting of rows and get max value. See how to select max of mixed string/int column.

2: Remove all characters from a string. Source

string intPartInKeyString = Regex.Replace(id, "[A-Za-z]", ""); // Remove all non digits

3: Get integer by String to int conversion: Source

int maxIntValueInKey = Convert.ToInt32(intPartInKeyString);

4: Get new Id by padding zeros to incremedted id: Source

string newId = "P" + (++maxIntValueInKey).ToString().PadLeft(4, '0');

Upvotes: 1

Related Questions