SQLite + Linq => Crap

  • C#

Es gibt 3 Antworten in diesem Thema. Der letzte Beitrag () ist von slice.

    SQLite + Linq => Crap

    Ich habe irwie immer nur komische Probleme :P

    Naja wie dem auch sei.
    Ich habe eine SQLite Datenbank.
    Aufbau is easy:

    per dblinq2007 habe ich nun eine Main.cs gemacht:
    LONG

    C#-Quellcode

    1. //
    2. // ____ _ __ __ _ _
    3. // | _ \| |__ | \/ | ___| |_ __ _| |
    4. // | | | | '_ \| |\/| |/ _ \ __/ _` | |
    5. // | |_| | |_) | | | | __/ || (_| | |
    6. // |____/|_.__/|_| |_|\___|\__\__,_|_|
    7. //
    8. // Auto-generated from main on 2012-07-05 16:44:51Z.
    9. // Please visit http://code.google.com/p/dblinq2007/ for more information.
    10. //
    11. namespace Social_Network.NET_Server.Databases
    12. {
    13. using System;
    14. using System.ComponentModel;
    15. using System.Data;
    16. #if MONO_STRICT
    17. using System.Data.Linq;
    18. #else // MONO_STRICT
    19. using DbLinq.Data.Linq;
    20. using DbLinq.Vendor;
    21. #endif // MONO_STRICT
    22. using System.Data.Linq.Mapping;
    23. using System.Diagnostics;
    26. public partial class Main : DataContext
    27. {
    29. #region Extensibility Method Declarations
    30. partial void OnCreated();
    31. #endregion
    34. public Main(string connectionString) :
    35. base(connectionString)
    36. {
    37. this.OnCreated();
    38. }
    40. public Main(string connection, MappingSource mappingSource) :
    41. base(connection, mappingSource)
    42. {
    43. this.OnCreated();
    44. }
    46. public Main(IDbConnection connection, MappingSource mappingSource) :
    47. base(connection, mappingSource)
    48. {
    49. this.OnCreated();
    50. }
    52. public Table<Settings> Settings
    53. {
    54. get
    55. {
    56. return this.GetTable<Settings>();
    57. }
    58. }
    60. public Table<Users> Users
    61. {
    62. get
    63. {
    64. return this.GetTable<Users>();
    65. }
    66. }
    67. }
    69. #region Start MONO_STRICT
    70. #if MONO_STRICT
    72. public partial class Main
    73. {
    75. public Main(IDbConnection connection) :
    76. base(connection)
    77. {
    78. this.OnCreated();
    79. }
    80. }
    81. #region End MONO_STRICT
    82. #endregion
    83. #else // MONO_STRICT
    85. public partial class Main
    86. {
    88. public Main(IDbConnection connection) :
    89. base(connection, new DbLinq.Sqlite.SqliteVendor())
    90. {
    91. this.OnCreated();
    92. }
    94. public Main(IDbConnection connection, IVendor sqlDialect) :
    95. base(connection, sqlDialect)
    96. {
    97. this.OnCreated();
    98. }
    100. public Main(IDbConnection connection, MappingSource mappingSource, IVendor sqlDialect) :
    101. base(connection, mappingSource, sqlDialect)
    102. {
    103. this.OnCreated();
    104. }
    105. }
    106. #region End Not MONO_STRICT
    107. #endregion
    108. #endif // MONO_STRICT
    109. #endregion
    111. [Table(Name="main.settings")]
    112. public partial class Settings
    113. {
    115. private sbyte _canReadAbout;
    117. private sbyte _canReadBirthDate;
    119. private sbyte _canReadID;
    121. private sbyte _canReadMail;
    123. private sbyte _canReadRegDate;
    125. private sbyte _inSearch;
    127. private sbyte _showOnline;
    129. private string _uid;
    131. #region Extensibility Method Declarations
    132. partial void OnCreated();
    134. partial void OnCanReadAboutChanged();
    136. partial void OnCanReadAboutChanging(sbyte value);
    138. partial void OnCanReadBirthDateChanged();
    140. partial void OnCanReadBirthDateChanging(sbyte value);
    142. partial void OnCanReadIDChanged();
    144. partial void OnCanReadIDChanging(sbyte value);
    146. partial void OnCanReadMailChanged();
    148. partial void OnCanReadMailChanging(sbyte value);
    150. partial void OnCanReadRegDateChanged();
    152. partial void OnCanReadRegDateChanging(sbyte value);
    154. partial void OnInSearchChanged();
    156. partial void OnInSearchChanging(sbyte value);
    158. partial void OnShowOnlineChanged();
    160. partial void OnShowOnlineChanging(sbyte value);
    162. partial void OnUIDChanged();
    164. partial void OnUIDChanging(string value);
    165. #endregion
    168. public Settings()
    169. {
    170. this.OnCreated();
    171. }
    173. [Column(Storage="_canReadAbout", Name="canReadAbout", DbType="tinyint", AutoSync=AutoSync.Never, CanBeNull=false)]
    174. [DebuggerNonUserCode()]
    175. public sbyte CanReadAbout
    176. {
    177. get
    178. {
    179. return this._canReadAbout;
    180. }
    181. set
    182. {
    183. if ((_canReadAbout != value))
    184. {
    185. this.OnCanReadAboutChanging(value);
    186. this._canReadAbout = value;
    187. this.OnCanReadAboutChanged();
    188. }
    189. }
    190. }
    192. [Column(Storage="_canReadBirthDate", Name="canReadBirthDate", DbType="tinyint", AutoSync=AutoSync.Never, CanBeNull=false)]
    193. [DebuggerNonUserCode()]
    194. public sbyte CanReadBirthDate
    195. {
    196. get
    197. {
    198. return this._canReadBirthDate;
    199. }
    200. set
    201. {
    202. if ((_canReadBirthDate != value))
    203. {
    204. this.OnCanReadBirthDateChanging(value);
    205. this._canReadBirthDate = value;
    206. this.OnCanReadBirthDateChanged();
    207. }
    208. }
    209. }
    211. [Column(Storage="_canReadID", Name="canReadId", DbType="tinyint", AutoSync=AutoSync.Never, CanBeNull=false)]
    212. [DebuggerNonUserCode()]
    213. public sbyte CanReadID
    214. {
    215. get
    216. {
    217. return this._canReadID;
    218. }
    219. set
    220. {
    221. if ((_canReadID != value))
    222. {
    223. this.OnCanReadIDChanging(value);
    224. this._canReadID = value;
    225. this.OnCanReadIDChanged();
    226. }
    227. }
    228. }
    230. [Column(Storage="_canReadMail", Name="canReadMail", DbType="tinyint", AutoSync=AutoSync.Never, CanBeNull=false)]
    231. [DebuggerNonUserCode()]
    232. public sbyte CanReadMail
    233. {
    234. get
    235. {
    236. return this._canReadMail;
    237. }
    238. set
    239. {
    240. if ((_canReadMail != value))
    241. {
    242. this.OnCanReadMailChanging(value);
    243. this._canReadMail = value;
    244. this.OnCanReadMailChanged();
    245. }
    246. }
    247. }
    249. [Column(Storage="_canReadRegDate", Name="canReadRegDate", DbType="tinyint", AutoSync=AutoSync.Never, CanBeNull=false)]
    250. [DebuggerNonUserCode()]
    251. public sbyte CanReadRegDate
    252. {
    253. get
    254. {
    255. return this._canReadRegDate;
    256. }
    257. set
    258. {
    259. if ((_canReadRegDate != value))
    260. {
    261. this.OnCanReadRegDateChanging(value);
    262. this._canReadRegDate = value;
    263. this.OnCanReadRegDateChanged();
    264. }
    265. }
    266. }
    268. [Column(Storage="_inSearch", Name="inSearch", DbType="tinyint", AutoSync=AutoSync.Never, CanBeNull=false)]
    269. [DebuggerNonUserCode()]
    270. public sbyte InSearch
    271. {
    272. get
    273. {
    274. return this._inSearch;
    275. }
    276. set
    277. {
    278. if ((_inSearch != value))
    279. {
    280. this.OnInSearchChanging(value);
    281. this._inSearch = value;
    282. this.OnInSearchChanged();
    283. }
    284. }
    285. }
    287. [Column(Storage="_showOnline", Name="showOnline", DbType="tinyint", AutoSync=AutoSync.Never, CanBeNull=false)]
    288. [DebuggerNonUserCode()]
    289. public sbyte ShowOnline
    290. {
    291. get
    292. {
    293. return this._showOnline;
    294. }
    295. set
    296. {
    297. if ((_showOnline != value))
    298. {
    299. this.OnShowOnlineChanging(value);
    300. this._showOnline = value;
    301. this.OnShowOnlineChanged();
    302. }
    303. }
    304. }
    306. [Column(Storage="_uid", Name="uid", DbType="text", AutoSync=AutoSync.Never, CanBeNull=false)]
    307. [DebuggerNonUserCode()]
    308. public string UID
    309. {
    310. get
    311. {
    312. return this._uid;
    313. }
    314. set
    315. {
    316. if (((_uid == value)
    317. == false))
    318. {
    319. this.OnUIDChanging(value);
    320. this._uid = value;
    321. this.OnUIDChanged();
    322. }
    323. }
    324. }
    325. }
    327. [Table(Name="main.users")]
    328. public partial class Users
    329. {
    331. private string _about;
    333. private System.DateTime _birth;
    335. private string _follows;
    337. private string _mail;
    339. private string _nick;
    341. private string _password;
    343. private System.DateTime _reGdAte;
    345. private string _uid;
    347. #region Extensibility Method Declarations
    348. partial void OnCreated();
    350. partial void OnAboutChanged();
    352. partial void OnAboutChanging(string value);
    354. partial void OnBirthChanged();
    356. partial void OnBirthChanging(System.DateTime value);
    358. partial void OnFollowsChanged();
    360. partial void OnFollowsChanging(string value);
    362. partial void OnMailChanged();
    364. partial void OnMailChanging(string value);
    366. partial void OnNickChanged();
    368. partial void OnNickChanging(string value);
    370. partial void OnPasswordChanged();
    372. partial void OnPasswordChanging(string value);
    374. partial void OnReGDateChanged();
    376. partial void OnReGDateChanging(System.DateTime value);
    378. partial void OnUIDChanged();
    380. partial void OnUIDChanging(string value);
    381. #endregion
    384. public Users()
    385. {
    386. this.OnCreated();
    387. }
    389. [Column(Storage="_about", Name="about", DbType="text", AutoSync=AutoSync.Never)]
    390. [DebuggerNonUserCode()]
    391. public string About
    392. {
    393. get
    394. {
    395. return this._about;
    396. }
    397. set
    398. {
    399. if (((_about == value)
    400. == false))
    401. {
    402. this.OnAboutChanging(value);
    403. this._about = value;
    404. this.OnAboutChanged();
    405. }
    406. }
    407. }
    409. [Column(Storage="_birth", Name="birth", DbType="datetime", AutoSync=AutoSync.Never, CanBeNull=false)]
    410. [DebuggerNonUserCode()]
    411. public System.DateTime Birth
    412. {
    413. get
    414. {
    415. return this._birth;
    416. }
    417. set
    418. {
    419. if ((_birth != value))
    420. {
    421. this.OnBirthChanging(value);
    422. this._birth = value;
    423. this.OnBirthChanged();
    424. }
    425. }
    426. }
    428. [Column(Storage="_follows", Name="follows", DbType="text", AutoSync=AutoSync.Never)]
    429. [DebuggerNonUserCode()]
    430. public string Follows
    431. {
    432. get
    433. {
    434. return this._follows;
    435. }
    436. set
    437. {
    438. if (((_follows == value)
    439. == false))
    440. {
    441. this.OnFollowsChanging(value);
    442. this._follows = value;
    443. this.OnFollowsChanged();
    444. }
    445. }
    446. }
    448. [Column(Storage="_mail", Name="mail", DbType="text", AutoSync=AutoSync.Never, CanBeNull=false)]
    449. [DebuggerNonUserCode()]
    450. public string Mail
    451. {
    452. get
    453. {
    454. return this._mail;
    455. }
    456. set
    457. {
    458. if (((_mail == value)
    459. == false))
    460. {
    461. this.OnMailChanging(value);
    462. this._mail = value;
    463. this.OnMailChanged();
    464. }
    465. }
    466. }
    468. [Column(Storage="_nick", Name="nick", DbType="text", AutoSync=AutoSync.Never, CanBeNull=false)]
    469. [DebuggerNonUserCode()]
    470. public string Nick
    471. {
    472. get
    473. {
    474. return this._nick;
    475. }
    476. set
    477. {
    478. if (((_nick == value)
    479. == false))
    480. {
    481. this.OnNickChanging(value);
    482. this._nick = value;
    483. this.OnNickChanged();
    484. }
    485. }
    486. }
    488. [Column(Storage="_password", Name="password", DbType="text", AutoSync=AutoSync.Never, CanBeNull=false)]
    489. [DebuggerNonUserCode()]
    490. public string Password
    491. {
    492. get
    493. {
    494. return this._password;
    495. }
    496. set
    497. {
    498. if (((_password == value)
    499. == false))
    500. {
    501. this.OnPasswordChanging(value);
    502. this._password = value;
    503. this.OnPasswordChanged();
    504. }
    505. }
    506. }
    508. [Column(Storage="_reGdAte", Name="regdate", DbType="datetime", AutoSync=AutoSync.Never, CanBeNull=false)]
    509. [DebuggerNonUserCode()]
    510. public System.DateTime ReGDate
    511. {
    512. get
    513. {
    514. return this._reGdAte;
    515. }
    516. set
    517. {
    518. if ((_reGdAte != value))
    519. {
    520. this.OnReGDateChanging(value);
    521. this._reGdAte = value;
    522. this.OnReGDateChanged();
    523. }
    524. }
    525. }
    527. [Column(Storage="_uid", Name="uid", DbType="text", AutoSync=AutoSync.Never, CanBeNull=false)]
    528. [DebuggerNonUserCode()]
    529. public string UID
    530. {
    531. get
    532. {
    533. return this._uid;
    534. }
    535. set
    536. {
    537. if (((_uid == value)
    538. == false))
    539. {
    540. this.OnUIDChanging(value);
    541. this._uid = value;
    542. this.OnUIDChanged();
    543. }
    544. }
    545. }
    546. }
    547. }

    Der Aufruf dabei:

    Quellcode

    1. D:\Git\SocialNetwork.NET\source\Social Network.NET Server\Databases>D:\Dateien\DLLs\dblinq\DbMetal.exe /provider:SQLite Source=Main.db" /code:Main.cs --namespace=Social_Network.NET_Server.Databases

    Wenn ich nun diesen Code ausführe:

    C#-Quellcode

    1. Databases.Users whatthefuck = new Databases.Users(){UID = id, Mail = splited[3], Nick = splited[2], Birth = d.Date, Password = splited[4], ReGDate = DateTime.Now, About = "", Follows = "" };
    2. instance.data.Users.InsertOnSubmit(whatthefuck);
    3. instance.data.SubmitChanges();

    instance is ne Instanz von Server.
    data is ne Instanz von Main.

    bekomme ich bei SubmitChanges() folgenden Fehler:

    Quellcode

    1. ArgumentNullException
    2. Der Wert darf nicht NULL sein.
    3. Parametername: key


    StackTrace:

    Quellcode

    1. bei System.Collections.Generic.Dictionary`2.FindEntry(TKey key)
    2. bei System.Collections.Generic.Dictionary`2.TryGetValue(TKey key, TValue& value)
    3. bei DbLinq.Data.Linq.Implementation.EntityTracker.FindByIdentity(IdentityKey identityKey) in z:\Development\DbLinq-0.20.1\src\DbLinq\Data\Linq\Implementation\EntityTracker.cs:Zeile 69.
    4. bei DbLinq.Data.Linq.Implementation.EntityTracker.RegisterToWatch(Object entity, IdentityKey identityKey) in z:\Development\DbLinq-0.20.1\src\DbLinq\Data\Linq\Implementation\EntityTracker.cs:Zeile 128.
    5. bei DbLinq.Data.Linq.DataContext.MoveToAllTrackedEntities(Object entity, Boolean insert) in z:\Development\DbLinq-0.20.1\src\DbLinq\Data\Linq\DataContext.cs:Zeile 576.
    6. bei DbLinq.Data.Linq.DataContext.InsertEntity(Object entity, QueryContext queryContext) in z:\Development\DbLinq-0.20.1\src\DbLinq\Data\Linq\DataContext.cs:Zeile 511.
    7. bei DbLinq.Data.Linq.DataContext.SubmitChangesImpl(ConflictMode failureMode) in z:\Development\DbLinq-0.20.1\src\DbLinq\Data\Linq\DataContext.cs:Zeile 451.
    8. bei DbLinq.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode) in z:\Development\DbLinq-0.20.1\src\DbLinq\Data\Linq\DataContext.cs:Zeile 406.
    9. bei DbLinq.Data.Linq.DataContext.SubmitChanges() in z:\Development\DbLinq-0.20.1\src\DbLinq\Data\Linq\DataContext.cs:Zeile 368.
    10. bei Social_Network.NET_Server.server.Connection.runCommand(String line) in D:\Git\SocialNetwork.NET\source\Social Network.NET Server\server.cs:Zeile 322.
    11. bei System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
    12. bei System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

    Jemand ne Idee, wie ichs beheben kann?

    öhm ja ^^ gute frage ich nutz dblinq nicht (hab davon gerade das erstema gehört)
    vll ists auch n parameter bei "SubmitChanges"? dafür müsste man ma schaun wo dort der wert genutzt wird etc...
    ich schaus mir ma eben an un meld mich denne wenn i was gefunden hab :)


    €dit: welche der dlls nutzt du?

    €dit: fail, kurze zwischen frage xD hast du in deiner db ein attribut als "primary key" geflaggt?
    wenn nich dann ignorier alles was ich gesagt hab un flagge ein attribut als primkey
    code.google.com/p/dblinq2007/issues/detail?id=225 :D

    Dieser Beitrag wurde bereits 3 mal editiert, zuletzt von „slice“ ()

Facebook