System.Data.SQLite
Hex Artifact Content
Not logged in

Artifact 662dcfddd525e81c2ff1e22068551b873cb1f38a:


0000: 0a 4f 70 74 69 6d 69 7a 65 20 53 51 4c 2e 0a 57  .Optimize SQL..W
0010: 72 69 74 65 20 73 6f 6d 65 20 64 6f 63 75 6d 65  rite some docume
0020: 6e 74 61 74 69 6f 6e 20 65 67 3a 20 68 6f 77 20  ntation eg: how 
0030: 74 6f 20 63 6f 6e 66 69 67 75 72 65 20 74 68 65  to configure the
0040: 20 70 72 6f 76 69 64 65 72 20 76 69 61 20 77 65   provider via we
0050: 62 2e 63 6f 6e 66 69 67 0a 44 75 6d 70 20 53 51  b.config.Dump SQ
0060: 4c 20 73 74 61 74 65 6d 65 6e 74 73 20 74 6f 20  L statements to 
0070: 73 6f 6d 65 20 73 6f 72 74 20 6f 66 20 68 75 6d  some sort of hum
0080: 61 6e 20 72 65 61 64 61 62 6c 65 20 66 6f 72 6d  an readable form
0090: 61 74 20 26 20 70 6f 73 73 69 62 6c 79 20 64 6f  at & possibly do
00a0: 63 75 6d 65 6e 74 20 74 68 65 6d 2e 0a 0a 3f 20  cument them...? 
00b0: 43 72 65 61 74 65 20 61 20 64 65 66 61 75 6c 74  Create a default
00c0: 20 44 42 20 6c 6f 63 61 74 69 6f 6e 20 26 20 6d   DB location & m
00d0: 61 6b 65 20 74 68 65 20 73 63 68 65 6d 61 20 61  ake the schema a
00e0: 20 72 65 73 6f 75 72 63 65 20 73 6f 20 6f 6e 65   resource so one
00f0: 20 63 61 6e 20 6a 75 73 74 20 70 6c 75 6e 6b 20   can just plunk 
0100: 74 68 65 20 70 72 6f 76 69 64 65 72 20 69 6e 20  the provider in 
0110: 61 6e 64 20 68 61 76 65 20 69 74 20 6a 75 73 74  and have it just
0120: 20 77 6f 72 6b 20 77 69 74 68 20 6c 69 74 74 6c   work with littl
0130: 65 20 6f 72 20 6e 6f 20 63 6f 6e 66 69 67 2e 0a  e or no config..
0140: 3f 20 49 6d 70 6c 65 6d 65 6e 74 20 50 72 6f 66  ? Implement Prof
0150: 69 6c 65 20 50 72 6f 76 69 64 65 72 0a 3f 20 49  ile Provider.? I
0160: 6d 70 6c 65 6d 65 6e 74 20 61 20 66 75 6c 6c 79  mplement a fully
0170: 20 64 79 6e 61 6d 69 63 20 53 69 74 65 4d 61 70   dynamic SiteMap
0180: 20 50 72 6f 76 69 64 65 72 20 73 6f 20 63 68 61   Provider so cha
0190: 6e 67 65 73 20 74 6f 20 74 68 65 20 44 42 20 67  nges to the DB g
01a0: 65 74 20 72 65 66 6c 65 63 74 65 64 20 69 6d 6d  et reflected imm
01b0: 65 64 69 61 74 6c 79 0a                          ediatly.