google-code-export / dblinq2007

Automatically exported from code.google.com/p/dblinq2007
Other
0 stars 0 forks source link

SQLite - INTEGER (64) dbMetal'd to c# int #306

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.Create a SQLite database with a table containing an INTEGER (64) column.
2.Run DBMetal on above.
3.Generated .dbml and .cs file use regular System.Int32 datatype

What is the expected output? What do you see instead?
I would expect it to map to a System.Int64.  Instead I see in the dbml file:
  <Table Name="main.Disk" Member="Disk">
    <Type Name="Disk">
      <Association Name="fk_Disk_0" Member="Server" Storage="_server" Type="Server" ThisKey="HostName" OtherKey="HostName" IsForeignKey="true" />
      <Column Name="DeviceID" Member="DeviceID" Storage="_deviceID" Type="System.String" DbType="varchar (8)" IsPrimaryKey="true" IsDbGenerated="false" CanBeNull="false" />
      <Column Name="FreeSpace" Member="FreeSpace" Storage="_freeSpace" Type="System.Int32" DbType="INTEGER (15)" IsPrimaryKey="false" IsDbGenerated="false" CanBeNull="false" />
      <Column Name="hostname" Member="HostName" Storage="_hostName" Type="System.String" DbType="varchar (50)" IsPrimaryKey="true" IsDbGenerated="false" CanBeNull="false" />
      <Column Name="lastUpd" Member="LastUpd" Storage="_lastUpd" Type="System.DateTime" DbType="DATETIME" IsPrimaryKey="false" IsDbGenerated="false" CanBeNull="false" />
      <Column Name="Size" Member="Size" Storage="_size" Type="System.Int32" DbType="INTEGER (64)" IsPrimaryKey="false" IsDbGenerated="false" CanBeNull="false" />
    </Type>
  </Table>

and in the .cs file:
...
    [Table(Name="main.Disk")]
    public partial class Disk : System.ComponentModel.INotifyPropertyChanging, System.ComponentModel.INotifyPropertyChanged
    {

        private static System.ComponentModel.PropertyChangingEventArgs emptyChangingEventArgs = new System.ComponentModel.PropertyChangingEventArgs("");

        private string _deviceID;

        private int _freeSpace;

        private string _hostName;

        private System.DateTime _lastUpd;

        private int _size;
...

What version of the product are you using? On what operating system?
1. DbLinq-0.20.1
2. WinXP SP3

Please provide any additional information below.

Original issue reported on code.google.com by tal...@gmail.com on 16 Feb 2011 at 9:06